Powerbi Desktop | Powerbi Service | Incremental Refresh

[ShahidYumeen]

I have premium per user license of powerbi.

I had my dashboards connected with a real time data placed in azure cosmos db using direct query.
The report was so slow so i changed the connection to import and implemented incremental refresh. After which although the data wasnt refreshing automatically the report became so quick in powerbi desktop.

When i publish it to powerbi service the report becomes so slow that its taking minutes to load , again more minutes when i apply slicer.

I am new to powerbi. Plz Helppp!

[v-yaningy-msft]

Hi, @ShahidYumeen 

Thanks for lbendlin's reply. Here's some additional content, the data will be loaded after the first release, it is normal for the loading time to last a few minutes, so try to avoid changing the original data structure; if you have a Premium license, you can enable the Large semantic model storage format setting before performing the first refresh operation in the service.

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
Large semantic models in Power BI Premium - Power BI | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lbendlin]

Incremental refresh in the Power BI service is reset whenever you make changes to your report meta data. It will be effective again after the second refresh.

Try to limit your report changes, or use ALM Toolkit to push these changes independently so the partitions are not destroyed.

[YumeenShahid]

Hi,
Thank you for the response.
Now i have implemented incremental refresh with direct query but i am not sure how fast i am gonna get my real time data coz the data is refreshed from the source after every 2 mins but its not reflecting on my report on powerbi service neither on powerbi desktop. when i refresh the datasource on the powerbi service, the changes are reflected in the report but it makes the report so slow that i think that i might got fired from my organization 🙂

[lbendlin]

Read about APR - Automatic Page Refresh.  You may need that if your Incremental Refresh table includes a "live"  partition for "Today"

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

[YumeenShahid]

Thanks for the response but i couldnt see any automatic page refresh by my side neither on powerbi desktop not on powerbi service. could you please give me a little details where could i get this option

Thanks

[lbendlin]

Your capacity admin needs to enable that.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh