Forum Discussion
Advocate IGetting reports / data out of PBD
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 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_tohidiI 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:
- Excel Power Pivot has a serious issue - see my post: https://social.msdn.microsoft.com/Forums/en-US/9aafb848-8853-40a5-b91f-f6094779c99e/onetoone-relationship-not-working?forum=sqlkjpowerpivotforexcel
- 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