Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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