Export to excel published report from sharepoint 2013 On premise site page

[Marjina]

I have embedded Power BI report on sharepoint 2013 On premise site page using Publish to web option. I am unable to find Export Data functionality. Can you please help on this issue?

[v-jiascu-msft]

Hi @Marjina,

There is a special function for Sharepoint that is "Embed in Sharepoint online". Please try it out. If you still want the feature you described, please create an idea here.

Best Regards,

Dale

[RMV]

Hi,

I'm also looking for the solution for the same question.

I'm using On premise Sharepoint, not Sharepoint Online.

Is the solution worked for Sharepoint on premise?

Regards,

[Marjina]

No such option is availble for SharePoint On-Premise.

So, I have created App workspace and shared with Entire organization. It provide one url to redirect which I have embedded on sharepoint page. If user wants to export data, Url redirects to shared report and their you will find export to excel option.

(Note: Pro license is required)

[RMV]

Hi @Marjina,

Thanks for the advise, appreciate it.

Btw, do you mean Pro license for the entire organization, or for the sharer?

[Marjina]

Hi,

Along with sharer, Whoever wants to export the data should have Pro license.