Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I am writing to you because I have a situation in the company where I work and I have not been able to find documentation to guide me to the solution.
I developed dashboards in PowerBI with a database for development and testing that is hosted in our development environment. However, to deploy the dashboard in production it must be changed the connection and it must be done by our customer because they are the owners of the data and for security reasons only they can do it.
Now, we have had many difficulties with this, from sending them the Desktop .pbix file to being able to make the connection change in Desktop because of our client's security settings.
The specific question is, it's possible to make a database connection change without the need to do it in the .pbix file? The dashboard is embedded in the application (which is .NET) and the embed code is updated through a .config file. Is it possible to configure the database connection in a .config file for PowerBI?
Thanks for your time.
Hi @dramirezkon ,
If I understand correctly, you would like to change the data source of the report which is embedded in .NET application. And due to the client's security settings, it must be done by your customer in the application side. Base on my research, I'm afraid that there is no good method to update the data source of Power BI dataset in the application side...
Please review the following links, and check if they can be used as an workaround...
1. Change Data Source Settings
Power BI - Change Data Source Settings
2. By Power Query parameter
Change the Source of Power BI Datasets Dynamically Using Power Query Parameters
3. Using XMLA endpoints
Using XMLA endpoints to change data sources in a Power BI dataset
Best Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.