Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Change database connection out of PowerBI Desktop for PowerBI report embeded on .NET application

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.

Community Support
Community Support

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.