Automated export of PBIX and RDL files from workspaces to sharepoint

[prathyoo]

Hi,

We have around 120 PBIX and RDL reports distributed in around 8 workspaces. These RDL and PBIX files are handled by different DEV teams and do undergo changes and refinements over time. So, we were looking to have a weekly export of each of these files and to keep a copy in sharepoint. We were able to figure this out using Power Automate. Here is what we did -

The first couple of actions was to create a folder in sharepoint -

Next, we initialized an array variable with the list of workspaces that we want the rest of the flow to work with -

And for each workspace, we get the Workspace Id or the group id using the API call to https://api.powerbi.com/v1.0/myorg/groups. This is done using the action Get Web Resource (HTTP with Azure AD). This circumvents the need to have an app registration for calling api.powerbi.com.

The subsequent steps are pretty straight forward and involves creating sub folders with the name of the workspace and using the following two API calls to list the reports in the workspace to get the report id and then to export the reports -

The entire process of export of 120 PBIX and RDL files took approximately 13 minutes (including a 95 MB master dataset pbix file). The reportType output was used to determine the extension of the file as shown in the expression in the above action.

[jedwards_CSS]

Has anybody done this to a local drive folder?

[nabilrizvi]

Hi, I am getting errors. Question: is there only one loop or three loops? Where did variable called id come from and and same with Apply_to_each_3?

[Vanessa250919]

Hey ! thanks for you post... My folder stay empty .. One idea ?

[v-henryk-mstf]

Hi @prathyoo ,

Thank you for sharing. For this kind of sharing, I suggest you can post to blog forum.

You can mark this original post as a standard answer to help the other members find it more quickly. Looking forward to your reply.😊

Best Regards,
Henry

[prathyoo]

Hi @v-henryk-mstf ,

Thanks. Yes, next time I will try and create a blog post. For this one I am not sure how to mark the post as a "Standard Answer". I couldn't find such an option on the page (but I might be missing some trick).

[v-henryk-mstf]

Hi @prathyoo ,

In general, you can see something like "accept as solution" in the following screenshot, click on it.

Best Regards,
Henry