Forum Discussion
How to export Power BI Dashboard File (.pbix) from Dev Environment and import to Production?
I have created a dashboard in Development environment Power BI.
Data Source: SQL Server of Dev Environment
I want to export this Dashboard to Production environment and making sure that the datasource connection is the new SQL Server.
New Data Source: SQL Server of Prod Environment
The SQL tables are same in both environments.
How can I export from Dev env and import to Prod env, whilst keeping a new connection of DataSource which has same tables?
Please ask me for more details if needed.
2 Replies
- edhans
Community Champion
You should be using parameters in your SQL table settings for the server name and database. Then you can change those in the service under Parameters, or with Deployment Rules if you are using Deployment Pipelines. See this article for more info on parameters in general.
- edhans
Community Champion
Was this helpful Anonymous - if not, can you reply with further questions?