Forum Discussion
Simulate incremental refresh in desktop
Hello !
I'm currently facing a disturbing issue :
One of my data sources, a web API provides queries which are suffering of a time limit : it only allows to retrieve the last 14 days.
So I need to store the data if I want to analyze a long period of time. In this objective I activated an incremental refresh which is working fine in the Service (only the last 2 days are refreshed so the previous ones are kept).
The problem is that if I want to bring some changes to the report, I go to the desktop and then when publishing it overwrite the data history with only the last 14 days...
Does anyone faced the same issue or knows a trick to avoid the loss of history ?
Best regards,
Cado
5 Replies
- parry2kSuper User
Cado_one check out this video Deploy Power BI dataset schema changes WITHOUT refreshing! - YouTube
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.
- parry2kSuper User
Cado_one you can use ALM Toolkit to deploy only model changes.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.
- Cado_oneResolver III
Hi parry2k
Thank you for the tip, I installed ALM Toolkit on my computer and now it's opened from PBI external tools I have no idea how to use it.
Could you please add a little bit more details concerning how to force Power BI to deploy only model changes ?
Thank you in advance,
Cado
- parry2kSuper User
Cado_one Maybe PPU license can help.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.