topic Re: PowerBI API ExportTo individual page/visual in Developer

PowerBI API ExportTo individual page/visual

Anonymous — Wed, 15 Dec 2021 08:10:58 GMT

Hello.

I'm trying to use the PowerBI API to export a specific page of a report as a PNG. The functionality works, giving me a zip file containing a PNG file for every page in the report.

My issue comes when I'm trying to select a specific visual or page by modifying the payload. Following the documentation, this is how my payload looks like

{ 'format': 'PNG', 'powerBIReportConfiguration': { 'settings': { 'locale': 'en-US', 'excludeHiddenPages': 'true' }, 'pages': [ { 'pageName': 'Test report page', } ] }

But I am still getting a zip file with all the pages instead of just the selected one. Same thing happens when selecting a specific visual.

Re: PowerBI API ExportTo individual page/visual

lbendlin — Mon, 20 Dec 2021 01:07:47 GMT

The pagename is likely not what you think it is. It is more of a GUID based identifier. If you don't specify the right pagename the export will ignore your request and give you all pages.

Unfortunately the main documentation Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs is not very helpful. However, there's this : Export Power BI embedded analytics reports API - Power BI | Microsoft Docs which gives you the hint on how to fetch the page names via a different API call.

Re: PowerBI API ExportTo individual page/visual

Anonymous — Mon, 20 Dec 2021 08:12:43 GMT

Hello!

Thank you for your reply! I used the Get Pages API Endpoint and I noticed that it gave both a "Name" and a "Display Name", just like you mentioned. I tried running the same code using the GUID-like given to me by the API, but I still get all of the pages in the report.

Could I be missing something in the payload that makes the API ignore it?

Re: PowerBI API ExportTo individual page/visual

lbendlin — Mon, 20 Dec 2021 11:52:39 GMT

You can use the sandbox to try the API call in the service. That helps with the debugging.

Re: PowerBI API ExportTo individual page/visual

Anonymous — Mon, 20 Dec 2021 12:56:43 GMT

So I have found the issue by pure luck. I was using Python's requests package to send the requests, and the payload was written as a Python dictionary and given to the package, since that work usually.

Apparently, this endpoint does not like that and I had to write it as a JSON string and pass it like that.

Re: PowerBI API ExportTo individual page/visual

jbronzo — Wed, 29 May 2024 02:20:16 GMT

can you share the payload for the report configuration to isolate just a single visual? I am working on the same use case. Thank you