Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Our data sources (each with its own query) are updated as and when needed, leading to several versions over weeks or months. This also means that there are older queries which will never receive any new data, but we need the earlier entered data to be available.
We have set up some analysis sheets in Excel and also dashboards in Power BI. There are so many older versions now that the refreshes take too long in both Excel and Power BI and also puts unnecessary strain on our servers. In Power BI I have unticked the refresh option from the Query Editor, but it only works with Desktop. The service still updates all the queries.
How can I set our older queries to have only static data and not refresh?
Solved! Go to Solution.
You do this by switching them to incremental refresh.
Hi @amalm
Thanks @lbendlin , but as i know, incremental refresh is possible for pro.
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
Best Regards
Maggie
You do this by switching them to incremental refresh.
Thanks for the reply, but how do I do this in Power BI and Excel Power Query?
I only have the Pro subscription, if that matters.
here's the documentation
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
unfortunately this is only available in Premium.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.