Forum Discussion
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?
 
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.
4 Replies
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!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.
Hi Kray ,
Does it make sense? If so, please accept it as solution. If you still need help, please share more details to us.
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.
