How to make exported files stored in the website where the Power BI report is embedded in?

[Cheetah]

Hi, all,

My Power BI report is embedded in a sharepoint webpage and my clients are colleagues who, by regulation, only work on and share the data internally.  Currently it seems the exported forms of the report (PPT, PDF or excel files) are automatically downloaded to local PCs.  Is there a way to make them stored on the sharepoint webpage where the Power BI report is embedded in? It would be of course possible for the users to download them there later (depending on the access right of the users that managed by the website).

I have a data confidentiality reason for this need, but cannot find a solution. 

Thanks for your help in advance!

[Cheetah]

@Icey Thank you for the reply. The solution you mentioned is exporting variables and data columns, I see no obvious way to extend it to keep the exported PPT or PDF files in a sharepoint folder. If it could be, could you elabrate it a bit more?  Thanks!

[Icey]

Hi @Cheetah ,

First, you can create a Power Automate visual in your report. And for the used flow, refer to this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Icey]

Hi @Cheetah ,

You may need to create a Power Automate button in your report like so:

Solved: Re: Can I export data from Power BI to SharePoint ... - Power Platform Community (microsoft....

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cheetah]

HI Icey,

Thank you very much for the great example, that's so educational!  I tried it and it works great! 

It works by adding an extra button,  while the original exporting button (in the Dropdown "Export")  that triggers a local-PC downloading is also available to users : 

For my purpose, what is still neccesary is to disable this original exporting functionalities.  is there a way to do that, or making the Power Automate Flow SUBSTITUTE them?  

Thank you!

[Icey]

Hi @Cheetah ,

There is a setting option in Admin Portal. Disable it, or only enable for specific group. But it will affect the entire organization. Can it meet your requirements?

And here are a few considerations and limitations with the Export to PDF feature. It may be helpful.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cheetah]

Hi @Icey 

Thank you for the effort. I tried to follow the way you directed. 
Is the Admin Portal the one in the Power BI service? I accessed this one as in the below graph by clicking the "settings" symbol on the upper-right corner and choosing "admin portal " in the dropdown. 

 

But seems I have no access to those options in Admin Portal you showed. I'm only managing a premium Power BI workspace. Is those options only available to the administrator of my orgonization, or I didn't find it at the right place? 

Thank you and best regards!

Cheetah

[Icey · Accepted solution]

Hi @Cheetah ,

"Tenant settings" can only be accessed by global admins and users who have the Power BI Administrator role.

Reference: About the Admin portal - Power BI | Microsoft Docs

You may try to hide the action bar when embedded like so:

Reference: Configure embedded Power BI report settings in a Power BI embedded analytics application | Microsoft...

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cheetah]

Thank you! Great solution and tutoring!