Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
PowerHelpBIlol
New Member

Slow Applying Changes / Slow Data Refresh / Direct Query Issue

I recently moved my data sources to use SQL sources but when I am trying to make changes and get it fully running - it is taking hours just to see it finally apply and refresh. I don't understand why it could be taken so long. 

 

Secondly, is there a way to have steps compatible with direct query mode? Just some columns are not identified properly. 

1 REPLY 1
christinepayton
Super User
Super User

When you're using SQL sources, apply your foldable steps first. The first step that breaks query folding will stop all folding for all steps after it, and folding really helps optimize refresh times:

https://learn.microsoft.com/en-us/power-query/power-query-folding

 

It's also preferable to create a view in SQL that has all the transformations and connect to that instead of doing them all in PQ (upstream transformation). 

 

Most "simple" actions are compatible with direct query, like filters, grouping, and basic calculations. I wasn't able to find a list of precisely which are, but if I recall it's mostly a speed thing where most are supported but you'll slow things down a lot as you add complexity. There's a few DAX functions that are completely unsupported. 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors