Forum Discussion
Change datasource from sql to tabular model
Hi Experts! We have a lot of dashboards designed for Power BI in the Cloud and started migrating them to SQL vNext Power Bi on prem. We achieved to convert the Power BI Model to a Tabular Model...
Hi erhardrainer,
As you know we can just change the connection information for the same data source type, we are not able to change the SQL Server data source to SSAS data source and keeping the report visuals fine. We need to open a new connection use SSAS to get data then re-design the report.
Best Regards,
Qiuyun Yu
With current limitations of PBI Report server that only integrates the "visual" part of PBI and not the "data" part, this is very bad news.
Is not it possible to dissociate 2 part in the XML file from the PBIX archive ??
No workaround avaible?