Forum Discussion

HB13's avatar
HB13
Helper I
4 years ago
Solved

XMLA & Incremental Refresh

Hi PBI gang   I have a massive and very very slow view in SQL that I pull into PBI (on a good day all 38 million rows take about 5+ hours to load) I set up an incremental refresh policy on this ta...
Need Help
Show and Tell
Tips and Tricks
  • Hariharan_R's avatar
    Hariharan_R
    4 years ago

    Hi HB13 

    Incremental Refresh - You can setup a incremental refresh for your fact tables or any tables which contains transactions with date column. Incremental refresh will help to create partitions on the huge table. When you refresh it will be quicker because instead of refreshing one big fact table it can easily refresh the partitions in parallel. 

     

    XMLA Endpoint - In context to refresh strategy, using XMLA you can see the partitions of the table that you defined in Power BI as part of incremental refresh. If you do refresh on the dataset, it will refresh all the tables in the dataset. Using XMLA, you can refresh one particular table or partitions.

     

    You also can use the below REST api to refresh tables, partitions etc.

     

    https://docs.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

     

    Thanks

    Hari

    Did I answer your question? Then please mark my post as the solution.
    If I helped you, click on the Thumbs Up to give Kudos.

    My Blog :: YouTube Channel :: My Linkedin


Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi HB13 

Incremental Refresh - You can setup a incremental refresh for your fact tables or any tables which contains transactions with date column. Incremental refresh will help to create partitions on the huge table. When you refresh it will be quicker because instead of refreshing one big fact table it can easily refresh the partitions in parallel. 

 

XMLA Endpoint - In context to refresh strategy, using XMLA you can see the partitions of the table that you defined in Power BI as part of incremental refresh. If you do refresh on the dataset, it will refresh all the tables in the dataset. Using XMLA, you can refresh one particular table or partitions.

 

You also can use the below REST api to refresh tables, partitions etc.

 

https://docs.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin