C# with PowerBI package: Cannot update RefreshSchedule

Question

I could get the Dataset from below code:

var client = new PowerBIClient(new Uri(_ApiUrl), _tokenCredentials);
var datasets = await client.Datasets.GetDatasetsAsync(new Guid(_workspaceId));

However, there is error when I run below code (datasets.Value.Count > 0):

await client.Datasets.UpdateRefreshScheduleAsync(new Guid(_workspaceId), datasets.Value[datasets.Value.Count - 1].Id, refreshSchedule);

Exception Error:

"Operation returned an invalid status code 'Forbidden'"

Supplement the API Permissions of PowerBI:

Make sure your account has rights to do this, and also the app registration used has rights to do this (Dataset.ReadWrite.All). — Andrey Nikolov
– Andrey Nikolov, Commented May 29, 2020 at 11:38
Hi @AndreyNikolov, I supplemented API Permissions of PowerBI for your reference. Dataset.ReadWrite.All is granted already and Backend is using this PowerBI to access PowerBI resources. Please advise, thanks. — DaiKeung
– DaiKeung, Commented Jun 1, 2020 at 5:39

Satya V · Accepted Answer · 2020-07-01 19:46:37Z

1

The delegated account through which the app is running / service principal should be added with full control to the dataset in addition to the app has permission at the Azure AD end.

Also, you can capture the server response to understand more on the error.

The Server response will have additional information on why the Service returned a Forbidden

Attached a sample output below :

The server response will be helping you more - especially the header with PowerBI error Info

answered Jul 1, 2020 at 19:46

Satya V

4,2241 gold badge8 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DaiKeung Over a year ago

Thanks @sathya_vijayakumar-MSFT. After I granted privilege to ServicePrincipal in PowerBI console and using your suggested method ScheduleNotifyOption.NoNotification, it is okay to update RefreshSchedule now.

Satya V Over a year ago

@DaiKeung, glad to know :)

Collectives™ on Stack Overflow

C# with PowerBI package: Cannot update RefreshSchedule

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related