Forum Discussion
create a relationship using rest api in powershell
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
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
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
1 Reply
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
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