Automate specific datasets in a report

[Anonymous]

Hi all,

can anyone please help to find out how can I automate the refresh of different tables in Powere BI at different time intervals?

[Anonymous]

Thanks Amit,

I was thinking to use SSIS earlier then dropped the idea and made a table out of my query result and made it a static table. It refreshes everyday with data addition in it with current date and then I can manipulate data in Power BI using dates.

Thanks for the suggestion though.

[Anonymous]

Hi @Anonymous ，

Do you want to refresh different tables in a specific dataset with different time intervals? For example, in dataset A, which contains tables a, b and c, you want to refresh these three tables every day at the following time intervals.
Table a: 2 times a day
Table b: once a day
Table c: 3 times a day

If this is the case, I'm afraid that Power BI does not support this feature for now. The refresh frequency is for entire dataset and can't configure for some one table...  You can raise a new idea in the ideas forum like the post below and add your comments there to make this feature coming sooner. 

Create a different schedule refresh for each table (with a single dataset)

Best Regards

[Anonymous · Accepted solution]

Done, Thanks.

Did it other way.

[Anonymous]

Hi @Anonymous ,

Thanks for your reply.  Whether your problem has been resolved? If yes, could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. And could you please share your solution here if it is convenient? Thanks for your sharing and time in advance. Much appreciated!

Best Regards

[Anonymous]

Thanks Amit.

[amitchandak]

@Anonymous , In Service refersh, I doubt I have seen a option like that.

But Using XMLA end point (Premium Feature) You can access it on SSMS, There we can refresh manually. I have not tested  scheduling