Getting reports / data out of PBD

[amir_tohidi]

Hello,

Apart from export to CSV or upload to Power BI web portal, is there any other way of extracting reports/data into other tools, namely Excel?

My company cannot use Power BI web portal and I want to be able to export locally.

Thanks in advance...

[v-yuezhe-msft]

Hi @amir_tohidi,

I agree with Eno1978. And personally, I would suggest that you share pbix file to your colleagues and recommend them to install Power BI desktop to view reports with the shared pbix file.

Thanks,
Lydia Zhang

[Seth_C_Bauer · Accepted solution]

@amir_tohidi The only thing I can make of this is that you want the PBI visuals.. Because you can pull your data into Excel already, why the jump to the Desktop?

I am not aware of any functionality to export visuals into Excel.

You can use Desktop files in the Power BI Embedded story, and also in SQL Server Rerporting Services 2016.

[amir_tohidi]

I need the export because not everyone in our organisation has PBD, but everyone has Excel (without Power Pivot). So, I need to be be able to extract reports from PBD to Excel so that people can view the report/data.

I am using PBD, because:

1. Excel Power Pivot has a serious issue - see my post: https://social.msdn.microsoft.com/Forums/en-US/9aafb848-8853-40a5-b91f-f6094779c99e/onetoone-relatio...
2. Excel 64 bit is not allowed in our company and yet our data models have tables with very large number of rows which can not be handled in 32 bit Excel Power Pivot