Forum Discussion
Refreshing In Power BI Service using Dataflow slower than Import SQL Statement
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
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?
3 Replies
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?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?