Automation of report downloading and storing in afolder on PBI workspace

[Anonymous]

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 

[Anonymous]

Thankyou soo much for the solution @Anonymous 🙂

[Anonymous · Accepted solution]

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.

[lbendlin]

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