Showing results for 
Search instead for 
Did you mean: 
maciejxy Visitor

Re: Exporting data from Power BI to Excel

still available on my June 2017 update version.  cannot export to .csv directly, only through a visualization table (bizarre I know).  There are also currently record limits on amount of records you are allowed to export.  this method is not ideal.

Re: Exporting data from Power BI to Excel

You can connect to the Power BI SSAS server if you know the localhost port.

I didn't read the whole thread so I don't know if @MattAllington chimed in at some stage but he has an excellent solution for this.  His post is about connecting to Power BI assets from exclel and if you read his code, you will see where the information you need is at.

cwoo Frequent Visitor
Frequent Visitor

Re: Exporting data from Power BI to Excel

Can  someone assist  I am in a report  view and would like to export to excel  .    The problem is the value of the calculated  fields in one of the coulumns in the report ( last years sales  using  calculate  and sameperiodlastyear function ) when exported to the excel sheet is not adding up .


However the simple  aggregrate field  for sum sales is adding up correctly .


If  there is a limitation on the ecport of calculated  measures , then how  do i ever report alot of  the reports  that are built  in Microsoft BI ?  Tableau allows you to export  the report straight  to  xcel  and  with calculated coulmns  as well.


Can anyone assist .





hughswells New Member
New Member

Re: Exporting data from Power BI to Excel

Woohoo! Export to XLSX just appeared. Happy New Year!

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 296 members 2,949 guests
Please welcome our newest community members: