cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amir_tohidi Regular Visitor
Regular Visitor

Getting reports / data out of PBD

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...

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Getting 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.

Near SE WI? Join our PUG Milwaukee Brew City PUG
3 REPLIES 3
Highlighted
Super User
Super User

Re: Getting 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.

Near SE WI? Join our PUG Milwaukee Brew City PUG
amir_tohidi Regular Visitor
Regular Visitor

Re: Getting reports / data out of PBD

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

 

 

 

 

 

Moderator v-yuezhe-msft
Moderator

Re: Getting reports / data out of PBD

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.