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
Revolutionize Your Power BI Experience with AI!
10 hours ago
Two New Power BI/Power Query Books
It’s time for another one of my occasional posts about free books that I’ve been given that you might be interested to check out. ...
11 hours ago
Unlock the Secrets of Power BI Mastery! 🚀
13 hours ago
Power BI Sales Performance Report
3 days ago