Forum Discussion
How to create relationships between tables
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!
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
3 Replies
Correct, this can only be done in Power BI Desktop or through XMLA queries. The Service user interface does not yet support that.
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
