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.

[tfrank0910]

@prathyoo Thank you for this, it's really helpful! I'm trying to implement but I keep getting an error saying the file is encrypted or corrupted. Any thoughts? Would you be able to share additional screenshots of your setup? I'm wondering if I'm missing a step or setting.

[prathyoo]

That is the issue with any Power BI report created directly from the Power BI service. You will notice that in the Power BI service, you cannot download those report PBIX. My solution only works for Power BI reports that were created and published using Power BI Desktop.

[tfrank0910]

These were created and published through PowerBi Desktop. I've tried multiple reports and it happens with all of them. I even created a new one with a simple data set and a single table just to make sure it wasn't some sort of size limitation but that failed too.

[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