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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

How to refresh one dataset many times in one go?

There is one report and user needs to refresh that dataset many times in Power BI. 

How we can achieve it in one go? Is there any scripts to fulfill this? 

1 ACCEPTED SOLUTION

Hi,  @Anonymous 

If your datasets operate in import mode and you don't want to go everytime and schedue a refresh for that, you can consider using DirectQuery mode/LiveConnect mode instead.

This way, the report's data is in near real-time whenever you access the report.

Data refresh in Power BI 

You can also try Powershell/Power Automate to refresh dataset, I think this blog could help you better to use it:

Using-the-power-bi-api-with-powershell-scripts-refreshing-your-dataset 

https://www.youtube.com/watch?v=-8NlEeIIRiQ 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

4 REPLIES 4
Tahreem24
Super User
Super User

@Anonymous Not quite understood your requirement. But with the Pro License you can refresh upto 8 times per day and with PPU and Premium you can refresh upto 48 times per day.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@Anonymous , What do mean by many times in one go?

 

I am hopeful, you are not looking for incremental

Anonymous
Not applicable

Need to refresh one dataset many times. But user don't want to go everytime and schedue a refresh for that. 

So is there any script or method to schedule refreshes at once for one dataset?

Hi,  @Anonymous 

If your datasets operate in import mode and you don't want to go everytime and schedue a refresh for that, you can consider using DirectQuery mode/LiveConnect mode instead.

This way, the report's data is in near real-time whenever you access the report.

Data refresh in Power BI 

You can also try Powershell/Power Automate to refresh dataset, I think this blog could help you better to use it:

Using-the-power-bi-api-with-powershell-scripts-refreshing-your-dataset 

https://www.youtube.com/watch?v=-8NlEeIIRiQ 

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.