Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
smpa01
Super User
Super User

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.

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
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

@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.

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
selimovd
Super User
Super User

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
 

@selimovdthanks, anything for DF?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors