Forum Discussion
PowerBI data refresh using RestAPI
I wrote a script to update my PowerBI dataset using PowerShell and PowerBI RestAPI, which is a SQL database connected via DirectQuery. However, after 8 refreshes, I get the following error. Is the limitations for refreshing a PowerBI desktop 8 times per day even using the RestAPI?
Exception calling "Send" with "1" argument(s): "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Authentication Required.
Learn more at"
At C:\scripts\update_script.ps1:37 char:13
+ $SMTPClient.Send( $emailMessage )
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : SmtpException
Data refresh
For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits datasets on shared capacity to eight daily refreshes. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh
7 Replies
Data refresh
For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently. Power BI limits datasets on shared capacity to eight daily refreshes. If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings.
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh
Thanks for the reply siopow. I believe the "on-demand" refreshes, if one were to do it manually, is unlimited per day. Additionally, according to documentations from Microsoft, the RestAPI refreshes should have unlimited capability. Maybe they changed it since RestAPIs were first introduced, because that article was written in 2018.
Anonymous which article are you refering to?
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdataset >> don't see a date here but:
In Shared capacities this call is limited to eight times per day (including refreshes executed via Scheduled Refresh)
In Premium capacities this call is not limited in number of times per day, but only by the available resources in the capacity, hence if overloaded, the refresh execution may be throttled until the load is reduced. If this throttling exceeds 1 hour, the refresh will fail.As per the above, it is indeed not limited but the # of times per day but by the available resources in the capacity. Can you confirm if your workspace is on Premium Capacity?