PowerQuery - Validating queries when saving is taking excessively long time

I'm struggling to be able to work efficiently with Dataflows as I am experiencing excessive times to 'validate' queries after pressing the 'Save & Close' button. For entities with even a minimal amou...

Data Modeling

ChrisRMcAlpine

New Member

6 years ago

This is still a huge query.

I can prep the M in Power BI Desktop, then copy that M into a blank query in dataflows, and experience time outs 9/10 times. Doing any kind of native query seems to time out the validating the schema, which is weird considering it's not even loading the data!

Why is this continually timing out? What are the contributing factors? Is it trying to run the entire query just to get an output schema? and if so why on earth would it do that for the entire query and then request you run the query again to populate the data??

Any help on this v-qiuyu-msft would be awesome.

Thanks

Chris Mcalpine

Completed Ideas

Set as landing page feature missing in Apr 2026 update (Build 2.153.1206.0) both in Desktop and Serv
Input Slicer Bug: Cursor jumps to position 0 and values cannot be cleared in Service
Input Slicer Causing Browser Tab Freeze in Public Links (Started April 24, 2026)
Small multiples not fitting to scale
Previously working Mac calender visual now gives me a error every time I touch it!
Text Slicer does not reset via Bookmarks or Clear All in Power BI Service (Service-only behavior)
Text Input Slicer is not reset by bookmarks in Power BI Service while working correctly in Power BI
Azure maps not displaying mapped data points in publish to web when location used
Azure Maps reference layer transparency behaves differently after publishing to Power BI Service
Desktop Application Bug?? - PBI desktop application left navigation icons always solid black