topic Re: Automating the refresh in Developer

Automating the refresh

Anonymous — Wed, 22 Dec 2021 05:59:06 GMT

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.

Re: Automating the refresh

lbendlin — Fri, 24 Dec 2021 14:48:28 GMT

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)

Re: Automating the refresh

Anonymous — Tue, 28 Dec 2021 01:38:24 GMT

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

Re: Automating the refresh

Anonymous — Tue, 04 Jan 2022 00:20:52 GMT

Thanks

Re: Automating the refresh

Anonymous — Tue, 04 Jan 2022 00:21:23 GMT

Done Thanks.