How to create relationships between tables

[Anonymous]

Hi there,

I have to use the PowerBI Service. I imported an excel sheet as a dataset and created a report. Here I want to create a relationship between some tables (being all in the same Dataset). But it seems, I cannot find the function or navigation to do so in PowerBI Service. I also could not find any help in the Dokumentation. I read some older posts, that this is not possible with PowerBI Service. So my question is, is this still the case? Or where can I find the function to create relationships in PowerBI Service or help with this topic?

Thanks!

[Anonymous]

Thanks for your answers and suggestions! It will look into it or try to install PowerBI Desktop on Virtual Machine...

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

True data manipulation including the relationship need to be done on PowerBI Desktop rather than PowerBI Service.

Download Power BI tools and apps 

If you are sure to perform such operations on the service,  you may have to use the PowerBI Dataset API to process it programmatically.

https://www.sqlshack.com/how-to-access-power-bi-rest-apis-programmatically/ 

https://powerbi.microsoft.com/en-us/blog/newdatasets/ 

More details  and limitations  please check this document:

Push Datasets - Datasets PostDatasetInGroup-relationship 

Best Regards,
Community Support Team _ Eason

[lbendlin]

Correct, this can only be done in Power BI Desktop or through XMLA queries.  The Service user interface does not yet support that.