create a relationship using rest api in powershell

[anonymous2]

Hi, I created a dataset by importing an excel file to Power BI service then I want to get the data and use it to create a relationship using rest api in powershell. I used the push method to push the dataset to the power bi service and managed to create the relationship between 2 tables but I do not know how to do it if the data isn't push to the power bi to create the relationship. Is it possible to do it?
Thank you.

@Anonymous @Burningsuit @Tutu_in_YYC @edhans @GilbertQ @ibarrau @amitchandak 

[v-cazheng-msft · Accepted solution]

Hi @anonymous2 ,

I think you have got the answer for this question from Solved: Create Relationship by Importing File with Power B... - Microsoft Power BI Community. So I will attach an official document related to XMLA endpoint that might help you.

Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

Using XMLA endpoints to change data sources in a Power BI dataset | Microsoft Power BI Blog | Micros...

Normally, get/read data to a report and build a model is mainly completed in Power BI Desktop application. Operations in Power BI service is very limited. For Premium, PPU user, XMLA endpoint will provide additional dataset management, governance, advanced semantic modeling, debugging, and monitoring. You need to use with tools like SSMS.

Per you description, I think there are two REST API may help you as well. For more details, please refer to these official documents.

Imports - Post Import In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Push Datasets - Datasets PostRows - REST API (Power BI Power BI REST APIs) | Microsoft Doc

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun