Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
devops-01
New Member

Automation of report downloading and storing in afolder on PBI workspace

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 

1 ACCEPTED SOLUTION
v-jtian-msft
Community Support
Community Support

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

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

Hello,@devops-01 .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

vjtianmsft_0-1736400026416.png

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.

View solution in original post

3 REPLIES 3
devops-01
New Member

Thankyou soo much for the solution @v-jtian-msft 🙂

v-jtian-msft
Community Support
Community Support

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

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

Hello,@devops-01 .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

vjtianmsft_0-1736400026416.png

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
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.