Automate specific datasets in a report

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

Thanks Amit.

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

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.