The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have created a query that collects specific information about every airport that exists in the world (from Wikipedia); the query includes invoking several nested functions.
I Applied the query while forgeting that there is around 40,000 + airports in the world and for the query to complete its run it would probably takes hours if not a full day !
(for every airport info to be fetched, it takes a second, I have 40,000 so I will need around +13 hrsto apply the query)
is there a way to save my query without waiting for it to be applied ? if I press cancel in the Apply query change box; I will lose the latest changes I made to the query; and I will have to re-do it again almost from scratch...
by the time of this post the query have fetched 4,000 rows; 37,000 rows left my poor PC still has 9 - 10 hrs of agony before completing the query.
You may just select File > Save > Apply later.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
112 | |
69 | |
46 | |
43 |
User | Count |
---|---|
186 | |
85 | |
76 | |
74 | |
56 |