Power Query – How to run a query only if data is returned
I had a requirement where I wanted to only have the underlying query run if there was data in the table. As shown in the image below a query would run, scan 20GB and then return zero rows. After making the changes what then happens is an initial query runs which will count the number of rows and if there...
The post Power Query – How to run a query only if data is returned appeared first on FourMoo | Power BI | Data Analytics.
Published on:
Learn moreRelated posts
Visualizing RATING Score in Power BI
1 day ago
Calculated Columns vs Measures in DAX
Level: Beginners Original: Feb 2016 It has been many years since Matt wrote his first take on Calculated Columns vs Measures, back in 2014 whe...
2 days ago
Empowering Frontline workers with Power BI
2 days ago
Unlock the Secrets to Power BI Mastery!
2 days ago
Can Marthe fix Patrick's Power BI Report?
2 days ago
Fabric Copilot to help write DAX queries improvements
This update comes with a marked improvement when generating DAX queries and conversationally editing them. This includes overall correctness o...
2 days ago