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

[Anonymous]

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.

[rpatkar · Accepted solution]

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

[mbutler71]

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]

Hi @Anonymous ,

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.

[Anonymous]

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