Forum Discussion
How to utlitze Power BI API to create a Power BI workspace in Power Automate?
I want to utilize Power BI API and Power Automate to perform below tasks
1) Create a Power BI workspace
2) Published several Power Bi files to the Power BI workspace created in task 1
3) extract links of those Power Bi files in task 2, and replace the Power BI links in SharePoint
Hi Anonymous,
You can refer to the following step to get correspond dataset and report id from group.
1. Create a power automate flow.
2. Add action with 'Groups - Get Groups' Api to get the group id list.
3. Looping above list items and use 'Reports - Get Reports In Group' API to get the detailed report id and dataset id.
5. Use the responds dataset and report id to replace parameters of template links to generate report links.
6. Invoke SharePoint related API and do update operations with above links.Regards,
Xiaoxin Sheng
1 Reply
Hi Anonymous,
You can refer to the following step to get correspond dataset and report id from group.
1. Create a power automate flow.
2. Add action with 'Groups - Get Groups' Api to get the group id list.
3. Looping above list items and use 'Reports - Get Reports In Group' API to get the detailed report id and dataset id.
5. Use the responds dataset and report id to replace parameters of template links to generate report links.
6. Invoke SharePoint related API and do update operations with above links.Regards,
Xiaoxin Sheng