Forum Discussion
Incremental Refresh on pbix
Hi
I'm importing folder as source in a file. Since most of the files don't change, its pain to have them refreshed every run unnecessarily.
Am I allowed to set up incremental refresh on pbix file. I've free account.
Regards
G1
Hey g1_p ,
incremental refresh works only for sources that support query folding, so only for relational databases.
With folders directly you cannot have incremental refresh, neither in the Power BI Service, nor Power BI Desktop.
You could however load your folders by Azure synapse and then do a incremental refresh on Azure synapse. But I guess that's now what you are looking for.
Sorry about that.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicg1_p there is no concept of incremental refresh in the Power BI desktop, it is used when you are doing schedule refresh in the Power BI service.
Also in case you go to service and sticking to the files this post can help, How you can incrementally refresh any Power BI data source (This example is a CSV File) - Reporting/Analytics Made easy with FourMoo and Power BI
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
4 Replies
- selimovd
Most Valuable Professional
Hey g1_p ,
incremental refresh works only for sources that support query folding, so only for relational databases.
With folders directly you cannot have incremental refresh, neither in the Power BI Service, nor Power BI Desktop.
You could however load your folders by Azure synapse and then do a incremental refresh on Azure synapse. But I guess that's now what you are looking for.
Sorry about that.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic- selimovd
Hey g1_p ,
as I said the data source must support query folding what requires a relational database. So in a normal state it won't work with files either. You can do some workarounds if the incremental refresh is a really necessary requirement. Check the article from Gilbert:
Be aware that incremental refresh only works in Power BI Service. You have to set it up in Power BI Desktop, but the incremental refresh itself only happens in Power BI Service. Maybe check the following article about incremental refresh:
All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only - RADACAD
As far as I remember incremental refresh also needs at least a Pro account. But I'm not sure if that's still the case.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
- parry2k
Super User
g1_p there is no concept of incremental refresh in the Power BI desktop, it is used when you are doing schedule refresh in the Power BI service.
Also in case you go to service and sticking to the files this post can help, How you can incrementally refresh any Power BI data source (This example is a CSV File) - Reporting/Analytics Made easy with FourMoo and Power BI
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
