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
Safeguard Data Privacy in DAX Optimizer
6 hours ago
Power BI and Devops Data
8 hours ago
Power BI Update October 2024 | Catch Up with Nags
13 hours ago
New Solution For Monitoring Power BI/Fabric Gateways
If you’re the admin for a large Power BI/Fabric tenant you’ll know how important it is to monitor your on-premises data gateways: ...
21 hours ago
Power BI Datamarts vs Fabric Datawarehouse
3 days ago
Power BI Desktop Gets a DARK MODE Makeover!
4 days ago
Using weekly calendars in Power BI
4 days ago