search

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
111 stars 44 forks source link

Report contains unsupported data source: of type: SHAREPOINTLIST. #41

Closed dixi1984 closed 2 years ago

dixi1984 commented 2 years ago

Is it possible to migrate Reports with Sharepoint List as DataSource. I'm getting this error;

Report contains unsupported data source: Source, of type: SHAREPOINTLIST.

gboreki commented 2 years ago

Unfortunately sharepoint list datasources are not yet supported in the powerbi service, so the automatic conversion is rejected by the service during upload.

The workaround for this scenario is to create a PBIDataset that uses the Sharepoint List directly in the service, and then point your RDL Report to that dataset. This tool does not automate that process, so you would need to create the datasets manually.