https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3215267#M42469 <P>As is the way, there is no possibility of changing their minds on this one</P> Tue, 02 May 2023 09:15:46 GMT DebbieE 2023-05-02T09:15:46Z https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3200277#M42334 <P>'We' are trying to export some Power BI reports into Power point&nbsp;</P> <P>&nbsp;</P> <P>It was tested successfully using a service user that has Admin access to the workspace where we have the reports</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PowerAutomate.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/905058iFB515C27F7A38C5C/image-size/large?v=v2&amp;px=999" role="button" title="PowerAutomate.png" alt="PowerAutomate.png" /></span></P> <P><SPAN><SPAN class="">We have a solution that changes through time and we don’t know exactly which reports we need to export we need to have a way to dynamically export the reports.</SPAN></SPAN></P> <P>&nbsp;</P> <P>We thought about doing this using a custom connector to iterate through the reports for the group:</P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group">https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group<BR /><BR />and the calling the export for each of them:<BR /><BR /></A><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group">https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group<BR /><BR />now our issue is that when I build the custom connector to get the reports in group I’m getting a 502 error:</A></P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group">&nbsp;</A></P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Error 502.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/905062iBC56CBE237457035/image-size/large?v=v2&amp;px=999" role="button" title="Error 502.png" alt="Error 502.png" /></span></A></P> <P><BR /><BR />We are using <STRONG>Basic Authentication</STRONG> here using the same service user and in theory this is connected&nbsp;<BR /><BR /></P> <P><LI-WRAPPER></LI-WRAPPER></P> <P>&nbsp;</P> <P><BR />Has anyone tried to connect to the Power BI APIs above using basic authentication and should this work?</P> <P><LI-WRAPPER></LI-WRAPPER></P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group"><STRONG><BR /><BR /></STRONG></A></P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group"><STRONG><LI-WRAPPER></LI-WRAPPER></STRONG></A></P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group"><STRONG><LI-WRAPPER></LI-WRAPPER></STRONG></A></P> <P><A class="" title="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" href="https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group" target="_blank" rel="noreferrer noopener" aria-label="Link https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file-in-group"><STRONG><LI-WRAPPER></LI-WRAPPER></STRONG></A></P> Fri, 21 Apr 2023 14:41:40 GMT https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3200277#M42334 DebbieE 2023-04-21T14:41:40Z https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3208094#M42388 <P>502 means internal server error.&nbsp; Either there was an ephemeral issue on the server, or your request is malformed in a way that you are crashing the server.</P> <P>&nbsp;</P> <P>You&nbsp; say that the REST API sandbox tests work?</P> Thu, 27 Apr 2023 00:13:36 GMT https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3208094#M42388 lbendlin 2023-04-27T00:13:36Z https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3210776#M42424 <P>I believe so. Bearing in mind i have put this up for someone elses project work, so I would have to ask for more details</P> Fri, 28 Apr 2023 08:16:49 GMT https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3210776#M42424 DebbieE 2023-04-28T08:16:49Z https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3211115#M42431 <P>I would tell them to reconsider. The whole functionality around exports is rather fragile and not scalable for enterprise use.</P> Fri, 28 Apr 2023 12:00:45 GMT https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3211115#M42431 lbendlin 2023-04-28T12:00:45Z https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3215267#M42469 <P>As is the way, there is no possibility of changing their minds on this one</P> Tue, 02 May 2023 09:15:46 GMT https://community.fabric.microsoft.com/t5/Developer/Exporting-Power-BI-reports-using-APIs-and-Power-Automate-Error/m-p/3215267#M42469 DebbieE 2023-05-02T09:15:46Z