topic Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual in Developer

Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

Bastienlin_ — Thu, 16 Jun 2022 14:44:59 GMT

Hello PBI Community,

I am wondering if it is possible to extract a PBI report with a PowerApps visual in it.
I am using the "Export to file for Power BI Reports" step in my Power automate flow to extract my report to pdf.
The problem is that what I see, instead of my PowerApps visual is this error message "This visual does not support exporting"
Seems weird as Power Automate, Power apps and Powerbi are all from Power Platform and should work well together...

Thank you for your help !

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

AmosHersch — Thu, 16 Jun 2022 15:18:46 GMT

Hi @Bastienlin_

Unfortunately the "Export to File" Power BI API doesn't support exporting PowerApps visual. You can see the list of limitations here: https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to#considerations-and-limitations

It doesn't really matter whether you call the API from Power Automate, or directly from your code.

Thanks,

Amos

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

Bastienlin_ — Thu, 16 Jun 2022 15:25:13 GMT

Hi @AmosHersch,
I am using the "Export to file for Power BI Reports" from a Power automate flow:

Does it have the same limitations as the "Export to File" API from Power BI that you just shared ?

Thank you for your help !

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

AmosHersch — Thu, 16 Jun 2022 15:32:15 GMT

Hi @Bastienlin_

The "Export to file for Power BI Reports" in Power Automate is just a convenient way for users to call the Power BI REST API (low code/no code approach). When you run the flow it calls the Power BI API with your credentials. So it does have the same limitations.

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

Bastienlin_ — Thu, 16 Jun 2022 15:38:51 GMT

Oh I see ! And one last question, does this PBI API have any difference with the export button in the PBI Service ? :

Thank you again for your help !

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

AmosHersch — Thu, 16 Jun 2022 15:45:59 GMT

The API requires the report reside on a dedicated capacity while the export button doesn't require that.

But the API allows more flexibility then the export button, you can provide filters, bookmarks, select which pages to export, export a single visual, use RLS, etc. The API also supports exporting to PNG format.

Regarding the Power Apps visual I believe the export button will return a similar result as the API.

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

Bastienlin_ — Thu, 16 Jun 2022 15:53:24 GMT

I see,

It is weird, but the export button from PBI Service manage to show the PowerApps visual (but there is no data, i don't know why). What is your opinion about it ? Shouldn't it show the same error message ?

Re: Extracting a PBI page with Power automate does not support exporting a PowerApps Visual

AmosHersch — Thu, 16 Jun 2022 16:03:40 GMT

I'm not sure about it, I'm more familiar with the API then the export button