Dubai Power BI & Power Apps User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
  • 1.  Power BI | Progress DB | SQL Server

    Bronze Contributor
    Posted Oct 28, 2018 11:55 PM
    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.

    ODBC_Connection.png

    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 

    SQL__Linked_Connection.png

    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.

     

     

    SQLConnection1.PNG

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


  • 2.  RE: Power BI | Progress DB | SQL Server

    Top Contributor
    Posted Oct 29, 2018 06:08 PM
    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
    ------------------------------