Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
jnrezk
Helper III
Helper III

how to edit a data source for power bi datasets live connection

 

Hi, 

I created a new report and connected to a data source using power bi datasets so there is a live connection to my main model. However, I need to change the connection to a different model and i don't see a way to delete the old or replace it with the new. I saw a edit source option before and now it seems gone - see below.

jnrezk_0-1644577850548.png

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @jnrezk ;

As far as I know, it replaces the old data set, and I did A test.

First, I connected data set A.

vyalanwumsft_0-1644892853634.png

Second, change to dataset B.

vyalanwumsft_1-1644892894392.png

 

vyalanwumsft_2-1644892932492.png

As we could see, the dataset haved changed.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

Hi, @jnrezk ;

As far as I know, it replaces the old data set, and I did A test.

First, I connected data set A.

vyalanwumsft_0-1644892853634.png

Second, change to dataset B.

vyalanwumsft_1-1644892894392.png

 

vyalanwumsft_2-1644892932492.png

As we could see, the dataset haved changed.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

What if I don't have permissions to dataset A? Can I still open live connected report and change the source to dataset B? Being said that I have permissions only to dataset B.

amitchandak
Super User
Super User

@jnrezk , Under transform data, data source setting -> you can change it to another power bi dataset

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
serpiva64
Solution Sage
Solution Sage

Hi,

i don't know if i've really undestood your question but Data source settings is inside Tranform data

Ok I see this now. When I do it does it replace the other data live connection? because I still see in the web version that the report is connected to the old dataset still. Is there a way for me to just delete the live connection altogether & re-add it under data source? @amitchandak @serpiva64 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.