Hi,
You can't pull all the data in your Power BI report. Try to identify which key metrics you want to measure in your report / dashboard
Limit out the table, number of columns (only relevant) & also limit the number of rows
You can do this by creating wrapper views which will limit # of columns & # of rows by defining aggregation at some level
Also try to avoid bringing data which is older than 3 years if business doesn't want to measure performance back then
First try with simple model & then extend it
------------------------------
Hasham Bin Niaz
Sr. BI Consultant
Karachi, Pakistan
------------------------------
Original Message:
Sent: 10-28-2018 11:55 PM
From: Gowrishankar Selvakumar
Subject: Power BI | Progress DB | SQL Server
Hi Everyone,
Good Day!
We have an ERP system where it stores the data in Progress DB. To visualize the same data in Power BI we are trying different approaches
Approach-1: Using the ODBC data connection in Power BI, I am able to pull the data but for some of the tables it is taking very long time to refresh the data.
Approach-2: Create Linked server for Progress DB in SQL DB and pull using the same ODBC driver and to refresh it takes more time
Approach-3: Dumping the data from Progress DB into a SQL table. I am able to pull some small tables into SQL DB but when I try to pull some large tables having 100K records and 100 columns then it is running for more than 5-6 hours and failing.
Kindly help me in finding the better approach to pull the data and use it in Power BI.
Let me know if you have any other queries.
Regards,
Gowrishankar
------------------------------
Gowrishankar Selvakumar
Power BI - Consultant
0523748318
------------------------------