Desktop Refresh vs Service Refresh with Premium Capacity

[abv46mac]

Hi all,

I have a Model that refres very fast in desktop (10 minutes with a 2 gb pbix) I uses a server with 32GB ram, but on the service the refresh takes more than 3 hours,  with P1 premium capacity (25Gb ram) is this normal?

PD; My Sources are only dataflow and Commondata service

thanks in advance

[GilbertQ · Accepted solution]

Hi there

I would not think it should take that long.

I would also look at the Premium Capacity App to see what else is taking and consuming the capacity in your premium node.

Have you looked at setting up incremental refreshing?

[venal · Accepted solution]

@abv46mac 

Can you please try to re-pro the issue by connecting the direct data sources(Ex:- SQL Server) instead of data flows from Power BI Desktop.

Create a report and publish it to the Power BI Service and check for the refresh with the "Refresh Now and Schedule Refresh".

Note:- If the schedule refresh is completed very less time compare to data flows report schedule refresh. You can raise a support ticket to investigate the issue and share the support ticket number here for reference.

If possible, please share the community link for quick traction on this issue.

If you have any other queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[GilbertQ · Accepted solution]

Hi there

I would not think it should take that long.

I would also look at the Premium Capacity App to see what else is taking and consuming the capacity in your premium node.

Have you looked at setting up incremental refreshing?