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.
I have report use multiple tables (i.e 10 tables) from same Azure DB. So, when I publish it to PoweBI service, there's one dataset. Now, among those 10 tables, 8 of them need refresh monthly and 2 of them need refresh weekly. How can I setup schedule refresh to achive it?
Solved! Go to Solution.
@Anonymous
By default, you cannot do that. But you can split your model into two models.
Publish these models into your workspace and configure the scheduled refresh.
After that, you can connect these two models using PowerBI dataset connectors. (PowerBI December 2020 update supports this feature.) If required, you can enable new relationships as well.
Reference:
Split an existing Power BI file into a model and report. https://powerbi.tips/2020/06/split-an-existing-power-bi-file-into-a-model-and-report/
DirectQuery for Power BI datasets https://youtu.be/68YvRs49VZM?t=88
Proud to be a Super User!
@Anonymous
By default, you cannot do that. But you can split your model into two models.
Publish these models into your workspace and configure the scheduled refresh.
After that, you can connect these two models using PowerBI dataset connectors. (PowerBI December 2020 update supports this feature.) If required, you can enable new relationships as well.
Reference:
Split an existing Power BI file into a model and report. https://powerbi.tips/2020/06/split-an-existing-power-bi-file-into-a-model-and-report/
DirectQuery for Power BI datasets https://youtu.be/68YvRs49VZM?t=88
Proud to be a Super User!
Thanks. It's very helpful
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.