Forum Discussion
How do I move reports and Dashboards between environments?
I don't understand the answers here. I have dev, test and production environments for my reporting data sources. We need these as we are continually developing new ways of slicing and dicing our data.
If I create a report that connects to my dev database, when I want to publish that report to production, I need to change the source of the data from my dev database server to my production database server. Currently, I can't see any simple way to do that, other than completely re-creating the report. Similarly, when a change is required, the only way I can see is to manually apply the change to the production report.
I may be missing something very basic here, please feel free to point out how stupid I am, as the answer to this would make my life much easier right now.
Hi SkinnyPete63, Have you found a solution to this? I am facing the same problem right now and couldn't find anything online.
We have asked this question when Microsoft is onsite, they confirmed that there is no straight forward path to migrate from one environment to another. I would use desktop to create reports and publish to the environment I need by connection to specific Service. Data Sources and connections need to be modified as needed.
I am not sure if this is the question but this how I'm doing it, assuming for example my Data Source is SQL Server Database:
I have a report named Report_Dev that is based on a Data Source named Source_Dev.
In order to create a production version of this report I open it in PowerBI Desktop and then from Edit Queries in the Home menu I select Data Source Settings.
I select Change Source and specify the production server (my production server has the same db schema but only the data is differrent) and database I.e., my Data Source is now Source_Prod. Then I save the PowerBI Desktop file as Report_Prod and publish to a workspace that I have named Prod_Workspace.
Yes, that's the problem and that's how we have ended up doing it. However, for highly complex reports that connect to several different data sources, that's a real pain. If you are publishing to a Power BI Report Server, you also have to set up the connections there as well, and the refresh schedule. Not really joined up, but I appreciate it's a difficult nut to crack!
