microsoft / RdlMigration

Tool that converts RDL from a SQL Server Reporting Services Server or Power BI Report server and published to a Power BI premium workspace
MIT License
110 stars 44 forks source link

Adjustment of SQL embedded data source to SQL Azure #10

Closed EricMicrosoft closed 2 years ago

EricMicrosoft commented 5 years ago

Description:

SQL Azure situation : with a specific set of datasource suffix in connectionstrings ( { ".database.windows.net", ".database.chinacloudapi.cn", ".database.cloudapi.de", ".database.usgovcloudapi.net" }), the "data source provider" in report file need to change from SQL to SQLAzure in order to successfully upload and work in PBI,

Though I handled this situation while converting the shared data source, it is still an issue for embedded data sources with those suffix.

Expected behavior:

as for now it would show failed to upload for those reports with embedded sql azure datasources, the tool should be able to recognize the SQLAzure in both embedded and shared data source and convert them from SQL