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.
Was wondering what the limits are of the Data Refresh API's. Can it make your non-directquery datasets more real-time by initiating a refresh avery 15 minutes (maybe even 5 minutes) whilst the best you can get out of scheduled refreshes is hourly?
Solved! Go to Solution.
@JanV wrote:
Was wondering what the limits are of the Data Refresh API's. Can it make your non-directquery datasets more real-time by initiating a refresh avery 15 minutes (maybe even 5 minutes) whilst the best you can get out of scheduled refreshes is hourly?
Based on my test, the Data Refresh API shares the same limitation(8 times per day) with "Schedule Refresh" with a Pro license. After exceeding the limitation, the API call would get the response saying "Number of refresh requests in last 24 hours exceeded limit". If you'd like to lift this limitation, you may have to buy a premium license(48 times per day), see this link).
For real time purpose, check Real-time streaming in Power BI
By the way, see a C# demo for the API.
@JanV wrote:
Was wondering what the limits are of the Data Refresh API's. Can it make your non-directquery datasets more real-time by initiating a refresh avery 15 minutes (maybe even 5 minutes) whilst the best you can get out of scheduled refreshes is hourly?
Based on my test, the Data Refresh API shares the same limitation(8 times per day) with "Schedule Refresh" with a Pro license. After exceeding the limitation, the API call would get the response saying "Number of refresh requests in last 24 hours exceeded limit". If you'd like to lift this limitation, you may have to buy a premium license(48 times per day), see this link).
For real time purpose, check Real-time streaming in Power BI
By the way, see a C# demo for the API.
Hi I was using the power shell script that you suggested to refresh. But when I schedule it in Windows Scheduler the script is not refreshing any data. Could you please help me in understanding how scheduling the script works
Hi I was using the power shell script that you suggested to refresh. But when I schedule it in Windows Scheduler the script is not refreshing any data. Could you please help me in understanding how scheduling the script works
Hi Eric,
I have created a scheduled task to mimic a refresh of a report based on a streaming dataset. I post around 200 rows every minute which is about 12,000 rows per hour.
I'm on a PRO License free trial at the moment but I'm still getting this error:
You are over your rows per hour limit for this dataset. To push more rows per hour, upgrade your account to Power BI Pro or retry your push later
Any insight would be greatly appreciated.
Thanks in advance,
iAm3G
Thx Eric, exactly what I was looking for!
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |