Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync

saadashraf — Wed, 01 Jul 2020 07:21:57 GMT

https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to

By using the above document link, i tried to export a power bi report from an application using this code in .net core framework.

var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
{
Settings = new ExportReportSettings
{
Locale = "en-us",
},
Pages = pageNames?.Select(pn => new ExportReportPage(pageName = pn)).ToList(),
};
var exportRequest = new ExportReportRequest
{
Format = format,
PowerBIReportConfiguration = powerBIReportExportConfiguration,
};

var url = XXX;
var content = new Dictionary<string, string>();
content["grant_type"] = "XXX";
content["resource"] = "XXX";
content["username"] = XXX;
content["password"] = XXX;
content["client_id"] = XXX;

var response = await APIHelper.MakeAsyncRequest(url, content);
var tokenresult = response.Content.ReadAsStringAsync().Result;
var OAuthResultModel = JsonConvert.DeserializeObject<OAuthResultModel>(tokenresult);
var authenticationResult = OAuthResultModel;

var credentials = new TokenCredentials(authenticationResult.AccessToken, "Bearer");
var client = new PowerBIClient(credentials);
var reportsResult = await client.Reports.ExportToFileInGroupAsync(GroupID, ReportID, exportRequest);

While executing the last line, code break and through an exception, i.e.:

{"Operation returned an invalid status code 'Forbidden"}

Re: Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync

lbendlin — Fri, 03 Jul 2020 02:26:00 GMT

Does it work in the sandbox?

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofileingroup

(click the Try it button)

Re: Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync

saadashraf — Fri, 03 Jul 2020 04:16:51 GMT

yes. This kind of json returned with status code 200.

topic Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync in Developer

Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync

Re: Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync

Re: Operation returned an invalid status code 'Forbidden while executing ExportToFileInGroupAsync