Is it possible to have shared datasets?

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

Is it possible to have shared datasets? #35

Closed pitanni closed 3 years ago

pitanni commented 3 years ago

After migration, reports have embedded dataset. It is possible to change (by script or in an automatic way) the embedded dataset in a shared dataset saved in a Power Bi Service?

gboreki commented 3 years ago

The powerbi service does not support shared datasets, since there is no equivalent artifact the best conversion is to transform into an embedded dataset. After this conversion you can open the report in Power Bi Report Builder and do further updates.

The closest transformation that would behave similar to a shared dataset would be to use a PowerBi DataSet and then point your report to that dataset. This unfortunately requires a lot of work in the reports.

Thanks -gboreki