Can you setup relationships with a Dataset?

[Anonymous]

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!

[LeonLiang]

@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]

Nope, this is what i see.

[v-piga-msft]

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

[Anonymous]

Good morning Cherry,

This has been a little while since i looked at this however i believe that i was working with the Desktop version. The main difference, that i can remember, was that the dataset i was using was already loaded as a dataset within the service.

It's been a while though and i have figured out a different solution. Thank you for the response though!