cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smpa01
Resident Rockstar
Resident Rockstar

What is scheduled to be refreshed at what time

Hi,

I am managing a premium workspace which contains 70+dataset and 100+df.

Each of these guys are scheduled to be run at different time.

I want to run a query that tells me the refresh schedule time by all the workspace components (both DF and dataset).

Is there anything in Power BI Rest API that currently does that?

Purpose- I want to spread out these guys to different time slots to better manage the capacity.

@nickyvv 

Thank you in advance.

 


New Animated Dashboard: Sales Calendar


5 REPLIES 5
v-kkf-msft
Community Support
Community Support

Hi @smpa01 ,

 

Does your problem have been solved? Based on my test, I could follow Dataflows - Update Refresh Schedule  to set up scheduled refresh for dataflow.

 

If it is solved, please mark a reply which is helpful to you.

 

Best Regards,
Winniz

smpa01
Resident Rockstar
Resident Rockstar

@v-kkf-msft  not reolved yet. Looking into options to write a PowerShell script to see if I can solve it, will keep this thread open for now till I find something..will update if and when I find a way out.


New Animated Dashboard: Sales Calendar


selimovd
Community Champion
Community Champion

Hey @smpa01 ,

 

sure, you should use the Get Refresh Schedule API request and loop over all workspaces and datasets:

Datasets - Get Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
smpa01
Resident Rockstar
Resident Rockstar

@selimovdthanks, anything for DF?


New Animated Dashboard: Sales Calendar


selimovd
Community Champion
Community Champion

Hey @smpa01 ,

 

I'm afraid that's not possible at the moment.

There is another post 2 months ago, where someone had the same issue. But they didn't post solution:

Get Dataflow Refresh Schedule from Power BI REST A... - Microsoft Power BI Community

 

Otherwise I would have proposed to try the dataflow REST API, but this doesn't seem to work: 

Dataflows - Update Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Docs

 

I try to ask in my network, but I'm afraid that might not be possible at the moment.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates