Forum Discussion

Paulx99's avatar
Paulx99
Kudo Kingpin
10 years ago

Exporting data from Power BI to Excel

Hi all   Does anybody know (as per the post below) when 'export data to CSV' was actually implemented in PBI Desktop ? I currently have PBI Desktop (Mar 2016) installed, but can't see it in there -...
Need Help
jhaatue1's avatar
jhaatue1
New Member
10 years ago

Looks like export to CSV is not available in BI any more. Can someone tell me why it was dropped.

  • cwoo's avatar
    cwoo
    Regular Visitor
    8 years ago

    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 .

     

    Colin 

     

     

  • maciejxy's avatar
    maciejxy
    Regular Visitor
    9 years ago

    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.

    • RobertSlattery's avatar
      RobertSlattery
      Responsive Resident
      9 years ago

      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.