Solved: Trigger Power BI dataset refresh via API using a f...

Anonymous · ‎11-20-2017

Hi,

We currently refresh all of our Power BI datasets based on schedules defined in the Power BI service. We are now looking into the possibility to trigger these dataset refreshes via Power BI's Web Service API. For that purpose we'd want use a technical account.

My question is: If we use Power BI Pro features / licenses for our reports, does that technical account require a Power BI Pro license as well just to trigger the dataset refreshes via the Web Service API? This should be possible using a free license since it's doing the same thing as the scheduler, right?

Thanks, Christian

Eric_Zhang · ‎11-20-2017

@Anonymous wrote:

Hi,

We currently refresh all of our Power BI datasets based on schedules defined in the Power BI service. We are now looking into the possibility to trigger these dataset refreshes via Power BI's Web Service API. For that purpose we'd want use a technical account.

My question is: If we use Power BI Pro features / licenses for our reports, does that technical account require a Power BI Pro license as well just to trigger the dataset refreshes via the Web Service API? This should be possible using a free license since it's doing the same thing as the scheduler, right?

Thanks, Christian

@Anonymous

Yes, the technical account requires a Power BI Pro license. Because the account has to be a member of the workspace to access the target reports while workspace is a Pro feature.

By the way, 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).

View solution in original post

Eric_Zhang · ‎11-20-2017

@Anonymous wrote:

Hi,

We currently refresh all of our Power BI datasets based on schedules defined in the Power BI service. We are now looking into the possibility to trigger these dataset refreshes via Power BI's Web Service API. For that purpose we'd want use a technical account.

My question is: If we use Power BI Pro features / licenses for our reports, does that technical account require a Power BI Pro license as well just to trigger the dataset refreshes via the Web Service API? This should be possible using a free license since it's doing the same thing as the scheduler, right?

Thanks, Christian

@Anonymous

Yes, the technical account requires a Power BI Pro license. Because the account has to be a member of the workspace to access the target reports while workspace is a Pro feature.

By the way, 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).

naren · ‎05-20-2018

Hi Eric,

I am new in power bi service, how to schedule refresh "Office 365 management api" reports in power bi service, Please share me if you have any documents to "ynr2096@gmail.com"

thanks

naren