topic Re: Power BI Export to file Error in Developer

Power BI Export to file Error

Anonymous — Thu, 18 Jun 2020 20:58:19 GMT

We are using the latest version of the API (V3)
I have copied the code examples from here -

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

in my 'PostExportRequest' function I have tried the following -

var Client = GetPowerBiClient(); var export = Client.Reports.ExportToFileAsync(reportId, exportRequest); export.Wait(); var exportResult = export.Result;

On the wait, I get a 'Forbidden' error

The user accessing this is acting as a Service Principal and is set to have full admin rights on the PowerBI settings.

on this -

var Client = GetPowerBiClient(); var export = Await Client.Reports.ExportToFileAsync(reportId, exportRequest);

This never completes and seems to run forever.

Re: Power BI Export to file Error

lbendlin — Sat, 20 Jun 2020 01:08:28 GMT

Aren't you supposed to check periodically for the rendering process to complete? It's asynchronous, so Wait() seems to be counter intuitive.

Re: Power BI Export to file Error

Anonymous — Mon, 22 Jun 2020 13:07:28 GMT

var Client = GetPowerBiClient(); var export = Await Client.Reports.ExportToFileAsync(reportId, exportRequest);

@lbendlin If I leave the code as this, it never finishes processing. As a dev, to test, I'm willing to wait maybe 5 minutes, but I left it going for an hour withno results

Re: Power BI Export to file Error

lbendlin — Mon, 22 Jun 2020 14:45:30 GMT

According to the documentation:

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

Quote: "The API is asynchronous. When the exportToFile API is called, it triggers an export job. After triggering an export job, use polling to track the job, until it's complete.

During polling, the API returns a number that represents the amount of work completed. The work in each export job is calculated based on the number of pages the report has. All pages have the same weight. If for example you're exporting a report with 10 pages, and the polling returns 70, it means that the API has processed seven out of the 10 pages in the export job.

When the export is complete, the polling API call returns a Power BI URL for getting the file. The URL will be available for 24 hours."

Re: Power BI Export to file Error

Anonymous — Mon, 22 Jun 2020 14:50:33 GMT

The export job never finishes.

It never hits the polling function.

The await on the export never comes back.

It should return in a second, max, because the report I'm exporting says only "Test"

Is there some hidden setting or framework version I need to set my project to?

I'm copying the documentation code and it is not working.

Re: Power BI Export to file Error

lbendlin — Mon, 22 Jun 2020 15:03:47 GMT

Doesn't look like the sample code to me. I think you are putting one "await" on top of another one?

Re: Power BI Export to file Error

Anonymous — Mon, 22 Jun 2020 15:06:21 GMT

/////// Export sample /////// public async Task<string> PostExportRequest( Guid reportId, Guid groupId, FileFormat format) { var client = GetPowerBiClient(); // new Power BI client instance var pages = client.Reports.GetPages(groupId, reportId); var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration { Settings = new ExportReportSettings { Locale = "en-us", }, }; var exportRequest = new ExportReportRequest { Format = format, PowerBIReportConfiguration = powerBIReportExportConfiguration, }; Export export = null; try { export = await client.Reports.ExportToFileInGroupAsync(groupId, reportId, exportRequest); // this never returns } catch (Exception ex) { } // Save the export ID, you'll need it for polling and getting the exported file return export.Id; }

Here's my full function.
Do I have a double await?

Re: Power BI Export to file Error

lbendlin — Mon, 22 Jun 2020 15:28:40 GMT

You define the pages but then do not specify them in the request.

(You also use Export export instead of var export but I guess that doesn't matter)

Re: Power BI Export to file Error

Anonymous — Mon, 22 Jun 2020 16:09:45 GMT

I deleted the line with 'pages' since yes, I'm not using them.

If I don't specify pages, then it'll export the whole report, right?

Re: Power BI Export to file Error

lbendlin — Mon, 22 Jun 2020 16:20:46 GMT

That would make too much sense. So better test with specifying the pages , just in case...

Re: Power BI Export to file Error

Anonymous — Wed, 24 Jun 2020 12:22:54 GMT

In the main application, the C# simply won't move past that line - do not know why. Nothing I do will work to move it past there.

Re: Power BI Export to file Error

Juniorflip — Wed, 01 Jul 2020 14:27:11 GMT

I am stuck in the same spot as well. The error I am getting is that the pageName is not declared

Pages = pageNames?.Select(pn => new ExportReportPage(pageName = pn)).ToList(),

does anyone know what pageName is supposed to be declared?

Re: Power BI Export to file Error

Anonymous — Wed, 01 Jul 2020 14:30:41 GMT

Good news:
If you don't specify the pages there, it'll print the full report every time.

It also seems to default to "en-us" as the locale if you don't specify.

It actually needs very minimal configuration

Just giving it a format in the export request is enough for the configto be done and complete.

Re: Power BI Export to file Error

Juniorflip — Wed, 01 Jul 2020 14:44:50 GMT

can you provide a code snippet of this part so that I can see?

var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
{
Settings = new ExportReportSettings
{
Locale = "en-us",
},

Pages = pageNames?.Select(pn => new ExportReportPage(pageName = pn.ToString())).ToList(),

};
var exportRequest = new ExportReportRequest
{
Format = fileFormat,
PowerBIReportConfiguration = powerBIReportExportConfiguration,
};

Re: Power BI Export to file Error

Anonymous — Wed, 01 Jul 2020 15:03:26 GMT

var fileFormat = FileFormat.PDF
var exportRequest = new ExportReportRequest
{
Format = fileFormat
};

here you go. this should work

Re: Power BI Export to file Error

Juniorflip — Wed, 01 Jul 2020 16:28:21 GMT

So I figure out my issue. I was trying to export as .PNG. When I did .PDF it works just fine. Apparently there is a setting that need to be set in the admin portal for .PNG but I can't find it. Does anyone have any luck enabling .PNG?

Re: Power BI Export to file Error

Anonymous — Wed, 19 May 2021 23:10:56 GMT

Have you found a resolution for this. Stuk with the same issue!

Re: Power BI Export to file Error

Anonymous — Tue, 21 Dec 2021 00:46:25 GMT

I found when I tried to export the file as a .PNG or a .CSV then the api call never worked and just hung permanently. But when I changed the export format to .PDF then it worked fine and the code was able to move on to the 'polling for export to finish' logic.

Re: Power BI Export to file Error

Anonymous — Tue, 21 Dec 2021 00:47:37 GMT

Thanks, changing the export file format to .PDF resolved this issue for me as well!

Re: Power BI Export to file Error

Anonymous — Fri, 24 Dec 2021 00:50:59 GMT

hi, did you use the sample code that is in the microsoft doc?

if not, can i see you your code .

thanks