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
Power BI Update - May 2025
1 day ago
Default XMLA configuration for Fabric and Power BI capacities changes to Read/Write
Starting June 9, 2025, Fabric and Power BI capacities will default to XMLA read/write operations. This change aids semantic model owners and c...
1 day ago