RdlMigration

This tool is designed to help customers migrate SQL Server Reporting Services reports (RDL) from their local server(s) to a Power BI workspace in their tenant. As part of the migration process, the tool will also:

• Convert any shared datasources and/or shared datasets in these report files to be embedded in the report and save the files locally to disk.

• Check for unsupported datasources or report components when uploading to Power BI

• Save the converted files that pass these checks to a specified Power BI Workspace.

• Provide a summary of the successful and unsuccessful assets migrated

Please note - None of the assets will be removed from the source as part of this process.

Usage:

# RdlMigration <your Base url endpoint> <file Path> <WorkspaceName> <client-id>

This command will save all the converted files to local disk and display the status of each file in the command window, as well as a file called ConversionLog.txt

---

Input details:

Base url endpoint:

This is set in the Reporting Services Configuration Manager under Web Service URL-> Report Server Web Service URL

File Path:

This refers to the relative path to your file or folder on the report server. If the path references a file, the tool will convert and push only that individual file. If the path references a folder, the tool will convert and try to push all the report files within that folder. This would include any reports contained in subfolders of the folder path you select.

Workspace Name:

This is the name of the workspace you want to upload your files to. Surround the name with quotation marks if there’s a space in the name. For example:

"Paginated Workspace"

client-id:

The Application Client ID that gives you permissions to read and write with the Power BI API:

To obtain this, do the following:

1. Go to https://dev.powerbi.com/apps .

2. Select Sign in with your existing account then select Next.

3. Provide an Application Name you want to call it.

4. Select Native for Application Type

5. Select the access permissions, for this application the minimum access are Read all Workspaces, Read and write all datasets, Read and write all reports

Click Register, and an application ID (Client-ID) will be provided to you.

Link : https://docs.microsoft.com/en-us/power-bi/developer/register-app

NOTE: In some cases, you may need an admin's approval for the app-id to work.