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.
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.
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.
User | Count |
---|---|
13 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
27 | |
3 | |
2 | |
2 | |
2 |