Progress DB taking long time to load records

[gowrishankar65]

Hi Everyone,

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 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

[v-yuezhe-msft]

@gowrishankar65,

Do you have to import all the 100 columns and all the rows? If not, you can use approach one. Select required columns and rows with specific SQL statement to import the data.

However, if you have to import all these columns and rows, you can use approach three, make sure that you use DirectQuery mode to connect to SQL database in Power BI Desktop.

Regards,
Lydia