Model reload time in Power Bi Services

[Syndicate_Admin]

Hello

I wanted to know why model load times vary in destok as in Services, I have a model that its full load in power bi destok takes about 8 minutes, but when I start a model update in power bi services it takes more than 50 minutes

[Ritaf1983 · Accepted solution]

Hi @Syndicate_Admin 

There are many aspects to troubleshoot the problem.
1. As you say, for the data source, do the follow steps:

• Model your data properly, always build a star schema!
• Remove/filter all data that isn’t needed for your report/analysis before loading into Power BI.
• Calculated columns and calculated tables are evaluated during refresh, can you replace a calculated column with a measure and avoid complicated operations.

2. Free and Pro user will refresh their reports in shared capacity, as we know shared capacity will has limitation in refresh rate, stroage mode and so on.

If we need better peformance in refresh like larger refresh rate or bigger stroage mode, we need to purchase Premium. You can find the comparation between Pro and Premium in this link: Explore Power BI plans

3. Consider using incremental refresh. Incremental refresh lets you refresh only the data that is new or has changed, refer to the this blog fot detailed steps.

4. Using dataflows to improve performance. Dataflows let you share the output of a Power Query query between multiple datasets. It do complex transformations once instead of inside multiple datasets and do transformations when the data for one query is ready, no need to wait until all data needed by the dataset is ready. Refer to this blog: How to Use Dataflow to Make the Refresh of Power BI Solution FASTER! - RADACAD

5. If you are using an on-premises data gateway to load data, locate the gateway machine close to the data source, make sure the gateway server has enough CPU and memory. Clustered gateways allow for the load to be spread across multiple servers.

Refer to this blog for more information.

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Idrissshatila]

Hello @Syndicate_Admin ,

yes it varies, since in desktop you're connected directly to the datasource, while on service there's a gateway between the source and power bi service.