Setting up relationships using Datasets

[Anonymous]

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?

 

[Anonymous · Accepted solution]

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.

Reference: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | Microsoft Power BI

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.