Power Bi export data in csv via SharePoint

[Eugene-CHN]

Hi guys.

I need your assistance 😞

We have some Power BI reports, embled on SharePoint. 

But when user export data, it downloads only on csv format. But if we works on Power Bi Service, we can choose how to export (excel or csv). And all data in csv file placed in one column... 

How to change it? 

How to export data from Power Bi report via Sharepoint on xls? 

Or how to fix downloding data on one column?

Thanks a lot for your help!

How to change it 

[v-xicai · Accepted solution]

Hi @Eugene-CHN ,

For Embed in SharePoint Online reports to work, the following is required:

• A Power BI Pro license or a Power BI Premium capacity (EM or P SKU) with a Power BI license.
• The Power BI web part for SharePoint Online requires Modern Pages.

You may encounter issues if using Internet Explorer 10. You can look at the browsers support for Power BI and for Office 365.

You can learn more: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo.

Best Regards,

Amy

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

[Eugene-CHN]

thanks, 

a got a solution, 

Report was embed like </> option and export didn't work correct.

Now i am changing for Power Bi embed option and export works fine. 

[Dgreen23]

@Eugene-CHN ,

Sorry to bring this forum back, but how did you embed your report differently?