Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a dataset in my power Bi report. where a table has to be refreshed on a particular day and all other have to be refreshed everyday. Can someone please help , how can I fix this?
After making it in power Bi desktop i have to publish it on service and then the refresh should be automated.
please help, it is very urgent for me.
Solved! Go to Solution.
Learn about using TMSL scripts to selectively refresh individual partitions in your dataset. You can schedule these queries with SSIS or Powershell . Not sure if it can be done in Power Automate.
Trigger a single table to refresh in the Power BI Service – Data – Marc (data-marc.com)
HI @Anonymous,
AFAIK, current power bi service schedule refresh feature does not support accurately config each data table refresh.
In my opinion, I'd like to suggest nested multiple refresh mode data table in one report and setting the schedule refresh. These refresh schedules will apply to the corresponding available type of data tables and the not matched other tables will use their own refresh methods.
Data refresh in Power BI - Power BI | Microsoft Docs
BTW, you can also consider refreshing lbendlin's suggestion if you are familiar with these external tools usages.
Regards,
Xiaoxin Sheng
Thanks
Learn about using TMSL scripts to selectively refresh individual partitions in your dataset. You can schedule these queries with SSIS or Powershell . Not sure if it can be done in Power Automate.
Trigger a single table to refresh in the Power BI Service – Data – Marc (data-marc.com)
Done Thanks.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |