Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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