cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abc_777
Resolver III
Resolver III

Export Power BI data to to Excel file as xlsx not csv

 Dear Concern,

 

is there any way to export power bi table/matrix report to Excel xlsx table format with free of cost? (not csv)

 

I tried report builder but no luck.

I know it can be done via power bi service which is paid but other that paid is there a way to do that?

 

and one more question under which power bi paid service option I can get the option to export report to excel

(powerbi pro or power bi premium per user or pwer bi  premium or all of these )

 

thanks

1 ACCEPTED SOLUTION

Guys its working in 60 days trail period as summarize not underline. thanks

View solution in original post

10 REPLIES 10
Fowmy
Super User
Super User

@abc_777

In the service, you can export that data to Excel as an .xlsx or .csv file. The option to export the data requires a Pro or Premium license as well as edit permissions to the dataset and report.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

I actually just tried the export function from the service from a free account and it's available:

export.JPG





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thanks @PaulDBrown for checking on that. I personally did not check as I did not have one. Can you check the link I posted and check if I understood it right please?

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy 

I confess that when I tried I was pleasantly surprised! (I too thought you needed at least a Pro account). I have a free account just for personal projects, including testing for PBI community questions.

The link is definitely the right reference for anything to do with exporting data from the service (and the conditions needed to ba able to do so).

This sentence may have lead to the confusion perhaps: "These limitations and considerations apply to Power BI Desktop and the Power BI service, including Power BI Pro and Premium."





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@PaulDBrown 

 

Interesting 🤔 

 

hope you haven't enabled Pro trial?

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy 

No Pro Trial enabled. I tried "sharing" and it prompted the message about Pro needed and trial period etc..





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






@Fowmy 

so there is no way to export data from power BI to Excel as xlsx format in withour lisence or free?

You can download from Power BI Desktop but the service needs at least a Pro license.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Guys its working in 60 days trail period as summarize not underline. thanks

Hello a query, why is it possible that when exporting an array or table from the BI to csv then excel, the information varies to the one that is initially displayed?

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors