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.
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?
Solved! Go to 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.
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
@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.
@Anonymous , What do mean by many times in one go?
I am hopeful, you are not looking for incremental
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
62 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |