cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chandanjhapbi12
Helper I
Helper I

Publish/Import Paginated reports(rdl) to Power BI Service using Power Shell/API

Hello,

Are there any Power shell script/API available to Publish/Import Paginated reports(rdl) to Power BI Service?

Below Post import in Group is not working.

POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/imports?datasetDisplayName={datasetDisplayName}

 

https://docs.microsoft.com/en-us/rest/api/power-bi/imports/postimportingroup

 

Thanks.

1 ACCEPTED SOLUTION
rpatkar
Power BI Team
Power BI Team

While not powershell scripts, we have a migration tool to help move reports from one-prem to cloud service - https://github.com/microsoft/RdlMigration

 

Regarding using powershell / API, have you checked out https://dev.to/kenakamu/upload-rdl-file-s-to-power-bi-via-api-28h

View solution in original post

4 REPLIES 4
rpatkar
Power BI Team
Power BI Team

While not powershell scripts, we have a migration tool to help move reports from one-prem to cloud service - https://github.com/microsoft/RdlMigration

 

Regarding using powershell / API, have you checked out https://dev.to/kenakamu/upload-rdl-file-s-to-power-bi-via-api-28h

View solution in original post

This PowerShell script works great. Thanks for posting. Looks like I'll be able to use this script as a base to include our SSRS reports in our Azure DevOps pipelines and automated deployment to our Power BI workspaces/environments.

v-lionel-msft
Community Support
Community Support

Hi @chandanjhapbi12 ,

 

You can find the answer here.

HOW TO CREATE AND PUBLISH PAGINATED REPORTS IN POWER BI SERVICE 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Lionel but it does not talk about deploying RDL reports using PowerShell or API.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors