cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DebbieE
Resident Rockstar
Resident Rockstar

Mix of Premium and Standard capacity workspaces. Dataflows running incredibly slowly in standard wor

I have a standard workspace that doesnt have much data in it.

 

The dataflows are running incredibly slowly and I dont have any way to figure out why?

 

could this be anything to do with our premium workspaces? Is there anyway for me to check and get more of an understanding as to why these are running incredibly slowly?

3 REPLIES 3
Eyelyn9
Community Support
Community Support

Hi @DebbieE ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

 

Best Regards,
Eyelyn Qin

Eyelyn9
Community Support
Community Support

Hi @DebbieE ,

 

Some data sources are working very slow. Sometimes it is the problem with the data source engine. sometimes, it might be the connector issue, sometimes it might be a limitation on the data source (such as the number of API calls in a time period). All of these situations cause the refresh of the Power BI report to become really slow because it has to wait for the data source’s response.

 

If you are using a dataflow with on-premises data sources, we can enable the additional log to gather additional log information of Enterprises data gateway. Then we can know the slow-performing queries while refresh, please refer to this document about the additional log: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance#slow-performin...

 

Refer to :

https://radacad.com/dataflow-a-remedy-slow-data-sources-in-power-bi

https://hevodata.com/learn/power-bi-etl-with-dataflows-4-easy-methods/

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DebbieE
Resident Rockstar
Resident Rockstar

no, its not data collected via the Gateway. Its in the Cloud.  I just need to have something to enable me to check and diagnose dataflows in a standard workspace. Or I wish Microsoft would specificy that dataflows should be premium only.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.