Forum Discussion
Solved
copy reports between workspaces
I am using two workspaces (Workspace1 and Workspace2). Workspace1 consits of 3 reports which are pointing to SQL Server I want to create copy of 3 those reports from Workspace1 to Workspace2 and poi...
Since you intend to change the data source, you will need the pbix that contains the semantic model and the report and then change the data source. Once published, you can download the remaining others as thin reports, change the semantic model they're using and then publish them.
Since your SQL Server and Snowflake have the same structure, you can just download the reports from Workspace1 as .pbix files, open them in Desktop, and change the data source.
In Power BI Desktop:
- Open the report
- Go to Transform Data >> Data source settings
- Switch the source from SQL to Snowflake (you’ll need the Snowflake connector)
- Apply changes and make sure everything loads fine
- Then just publish the report to Workspace2
That’s it the report layout stays the same, just now running on Snowflake. If the model is shared across reports, you’ll need to recreate or repoint the semantic model too