PowerBI data refresh using RestAPI

[rnian18]

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

[Anonymous · Accepted solution]

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 

[rnian18]

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]

@rnian18 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?

[rnian18]

I am talking about this article.  But it might be out of date.  https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

It is when they announced the data refrest APIs.  It says the API is not limited to eight times.

[Anonymous]

---

@rnian18 wrote:

I am talking about this article.  But it might be out of date.  https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

It is when they announced the data refrest APIs.  It says the API is not limited to eight times.

---

That's simply a blog post announcing it, that documentation link leads my previous post.

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdataset 

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. 

[rnian18]

Yup, your link has the latest information.  I will look for different ways to pull data into PowerBI Service

[Anonymous]

HI @rnian18,

Did these reply help with your scenario? If that is a case, you can choose the most suitable one and accept it as a solution to help others who faced similar issues. If not, please feel free to post here with detailed information to help us clarify these.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng