How to create related tables in PowerBI service?

[wittenbt]

I have a dataset from OMS that I would like to relate to another table that I imported from a spreadsheet.   I know how to do this in PowerBI desktop....Is there a comparable way to setup related tables in the Service?

[wittenbt]

Is there a way to make a relationship between 2 datasets in the Service like there is in PBI desktop?

[Seth_C_Bauer]

@wittenbt No - see answer to your other thread with the same question - here You can't connect the models in the Service. You could import seperately and report on seperately and show the visuals on the same dashboard, but I don't believe that is what you are after.

[Seth_C_Bauer · Accepted solution]

@wittenbt You can't add anything to your dataset in the Service. No modeling, calc columns, measures, relationship building, etc. All that has to be done in the desktop. Which hurts more if you are connecting to sources that are only available in the Service... 😞