topic Re: Refreshing In Power BI Service using Dataflow slower than Import SQL Statement in Service

Refreshing In Power BI Service using Dataflow slower than Import SQL Statement

Anonymous — Sat, 23 Nov 2019 19:07:03 GMT

I'm a Pro user and struggling to see the benefit of Dataflows for my SQL Server data.

I've created two reports with exactly the same tables. One relies on SQL statements imported into the model via a gateway. The other has the same tables with the same queries from a Dataflow that was refreshed over the gateway previously (this takes about 3 minutes).

The dataset refresh based just on the dataflow data sources takes just over 19 minutes to finish

The dataset based on the SQL import statement takes just under 6 minutes.

I thought the idea was if it was consuming the data from an already refreshed dataflow it would be much quicker. At least that's what this article alludes to: https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster

So, either I'm doing something wrong or there is some other problem. I don't know if the gateway set up has something to do with it (I can't see how as I'm not crossing it to refresh the dataset from a Dataflow). Anyone know what the optium requirements are for the server the gateway sits on if that's the case?

Many thanks

Re: Refreshing In Power BI Service using Dataflow slower than Import SQL Statement

venal — Sun, 24 Nov 2019 02:45:25 GMT

Anonymous

May i know the Gateway you are using? (On-Premises/Personal)

Is the Gateway is older or latest verison?

If it is the older version, please try to upgrade to the latest version.

https://www.microsoft.com/en-us/download/details.aspx?id=53127

I would like to suggest you to keep monitor this week and if the issue is persists with the perfromance, please raise a ticket.

Because there was few known issues going on with Data Flows, those bugs deploy it in this weekend.

Please refer the support page for known issues.

https://powerbi.microsoft.com/en-us/support/

If you have any concerns, 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?

Re: Refreshing In Power BI Service using Dataflow slower than Import SQL Statement

Anonymous — Mon, 25 Nov 2019 09:25:19 GMT

Thanks. It's an enterprise gateway and we upgraded it this morning.

I will keep testing it and see what times we get.

Re: Refreshing In Power BI Service using Dataflow slower than Import SQL Statement

venal — Tue, 26 Nov 2019 02:36:47 GMT

Anonymous

Hope it is working fine now.

If you have any 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?