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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Kray
Helper I
Helper I

Changing Data for Relation

Hello, I created a report on desktop and I refresh&publish to web. I created a lot of reports from that main report on web. I use a specific excel data for related for connecting my other datas. I changed this specific excel data on desktop and I created relations but I cant change it on web!  It is a big problem really. Is there any solution for now?

 

related.JPG

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

Hi @Kray ,

 

In service, it is default for the relationship between data sources, datasets, reports and dashboards. We can't change it in Service. 

 

If you change the data source in Desktop, you need to republish it and then Power BI will detect and correct its relationship automatically.

 

If I misunderstand, please share more details to us. We will be more clear.

 

Best Regards,
Xue Ding
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

4 REPLIES 4
v-xuding-msft
Community Support
Community Support

Hi @Kray ,

 

In service, it is default for the relationship between data sources, datasets, reports and dashboards. We can't change it in Service. 

 

If you change the data source in Desktop, you need to republish it and then Power BI will detect and correct its relationship automatically.

 

If I misunderstand, please share more details to us. We will be more clear.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Kray ,

 

Does it make sense? If so, please accept it as solution. If you still need help, please share more details to us.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your helping, sorry for late reply. I had added new table for relations and then wanted to change relation for 45 web reports. I didnt try to cancel old table relations, so I cant say that it works or not.  But I only wanted to learn if I can change relations on web or not.  It seems not possible as you said above. I gotta change it on desktop powerbi.

KBO
Memorable Member
Memorable Member

Hi @Kray ,

make me wonder you make your sources anonymous but you write that you publish your reports to web? You know that If you publish something to web even I can find this via google search?

Sorry is no answer to your question but I think this is important to meantion 🙂

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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