Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Can you setup relationships with a Dataset?

I am a Power BI novice and have just stepped into the pool with using Datasets. In my reports previously i was pulling data from Excel tables and setting up relationships between the tables. Everything was working great. However, once i tried to pull those same tables into a Power BI dataset i noticed that my relationships were gone and some of my visualizations were no longer working.

 

All of the usual ways to setup relationships appear to be greyed out or not available.

 

Can anyone give me any advice on whether or not i can setup relationships on datasets and / or how to do this?

 

Thanks!

Need Help

4 Replies

  • LeonLiang's avatar
    LeonLiang
    Frequent Visitor
    7 years ago

    Anonymous 

     

    Did you see the following in your PowerBI desktop? This is where you can set up relationships over your data sources. Or is this even greyed out?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Nope, this is what i see.

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        7 years ago

        Hi Anonymous ,

        If I understand your scenario correctly that you connect with Power BI Dataset in Power BI Service.

        If it is, I'm afraid that we cannot create the relationship in live connection in Power BI Desktop which is a limition.

        If if is possible, you could download the report as a pbix in Power BI Service and then you could open it in Power BI Desktop so that you could create the relationship.

        Best Regards,

        Cherry