Getting error when calling Power BI API Operation returned an invalid status code 'Forbidden'

rajeshlohar1974 — Sun, 23 Apr 2023 10:41:40 GMT

Hello,

I am using Power BI c# SDK to export Power BI report in PDF. I am getting error as "Operation returned an invalid status code 'Forbidden'". I have setup app registration in Azure Active Directory and assigned the required permissions. I am using Power BI PRO license.

Below is the code:

IConfidentialClientApplication app = ConfidentialClientApplicationBuilder
.Create(clientId)
.WithClientSecret(clientSecret)
.WithAuthority(new Uri(authority))
.Build();

string[] scopes = new string[] { $"{resource}/.default" };

AuthenticationResult result = null;

result = app.AcquireTokenForClient(scopes).ExecuteAsync().Result;
var tokenCredentials = new TokenCredentials(result.AccessToken, "Bearer");

var client = new PowerBIClient(new Uri("https://api.powerbi.com"), tokenCredentials);

FileFormat ExportFileFormat = FileFormat.PDF;

List<ExportFilter> eFilter = new List<ExportFilter>() {
new ExportFilter { Filter = "xxxxx=xxxxxx" }
};
var options = new ExportReportRequest
{
Format = ExportFileFormat
};
Guid ReportID = new Guid("xxxxxxx");
var exportResult = client.Reports.ExportToFile(ReportID, options);

Please help.

Re: Getting error when calling Power BI API Operation returned an invalid status code 'Forbidden'

AntrikshSharma — Mon, 24 Apr 2023 17:12:36 GMT

@rajeshlohar1974 Reports can only be exported with REST API if you have Premium of Azure capacity.

topic Getting error when calling Power BI API Operation returned an invalid status code 'Forbidden' in Developer

Getting error when calling Power BI API Operation returned an invalid status code 'Forbidden'

Re: Getting error when calling Power BI API Operation returned an invalid status code 'Forbidden'