Hello,
I am trying to incorporate a data from a Data Set into an existing report. There are only 3 tables I need from the Dataset so have only connected to those.
I have successfully created a relationship between one of the tables and my pre-exisiting dates table but would like to also create a relationship between the columns highlighted in yellow in the other two tables.
However, I get the message below when I try to create the relationships.
Does anyone know if there is a solution to be able to create relationships I need to successfully use a slicer to filter the data by month?
Hi @Anonymous ,
You cannot edit, delete or create new relationships in the same Power BI dataset or Analysis Services source. If you have edit access to these sources, you can make the changes directly in the data source instead.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You cannot edit, delete or create new relationships in the same Power BI dataset or Analysis Services source. If you have edit access to these sources, you can make the changes directly in the data source instead.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
