Automation of report downloading and storing in afolder on PBI workspace

Anonymous — Wed, 08 Jan 2025 10:02:20 GMT

Hello ,
I am trying to dowload all the published reports and storing it in a folder on workspace itself .
i tried using Selenium but was not able to generate the desired output

It would be really helpful if you help .

Thanks in advance

Re: Automation of report downloading and storing in afolder on PBI workspace

lbendlin — Wed, 08 Jan 2025 16:10:36 GMT

What's the business scenario? This doesn't seem to be a great way of doing things.

Re: Automation of report downloading and storing in afolder on PBI workspace

Anonymous — Thu, 09 Jan 2025 05:26:20 GMT

Hi,lbendlin ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,Anonymous .I am glad to help you.
I think you can try to use Rest API to download the same file from the specified workspace to the specified storage address and then use power shell/Rest API to publish the reports. Specify the workspaceID and publish the reports to the corresponding workspace.
DownLoad pbix files:
Reports - Export Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Be aware that there are some restrictions when downloading pbix files:
Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn

About Publish reports:
PowerShell:

Publish Power BI reports using PowerShell Cmdlet
Rest API:

Solved: How to upload a locally created PBIX file to the P... - Microsoft Fabric Community

You can also try the API federation Power Automate to automate these operations
Export and email a report with Power Automate - Power BI | Microsoft Learn

One thing to note:
Currently Power BI's folders are recognized more as paths than an actual optional path parameter. (You can get information about all the elements stored in a workspace using the API, a folder ID exists for content stored in a folder)

But currently, you may can not specify the folder ID in the API

When uploading a report, you cannot directly specify the folder ID where it will be stored.
I recommend that you manually move the report to the specified workspace folder after the automatic upload of the report.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Automation of report downloading and storing in afolder on PBI workspace

Anonymous — Thu, 09 Jan 2025 10:29:14 GMT

Thankyou soo much for the solution Anonymous 🙂

topic Re: Automation of report downloading and storing in afolder on PBI workspace in Report Server

Automation of report downloading and storing in afolder on PBI workspace

Re: Automation of report downloading and storing in afolder on PBI workspace

Re: Automation of report downloading and storing in afolder on PBI workspace

Re: Automation of report downloading and storing in afolder on PBI workspace