Forum Discussion

BrianD's avatar
BrianD
Regular Visitor
2 years ago
Solved

Unable to export to csv file

Hi,   We are currently unable to export a .csv file from power bi desktop. We are getting error message to state that we are unable to export as the file is to big despite in some cases there only ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi BrianD ,

    Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sukhraj_Ghuman's avatar
Sukhraj_Ghuman
Regular Visitor
2 years ago

Hi,

 

im having the same exact problem since yesterday, i tried with the method above (DAX Studio) but i can only export the table data (not visual) in P.Bi.

I want export from visuals! 

Thanks

foodd's avatar
foodd
Community Champion
2 years ago

Using Performance analyzer you are able to capture the DAX query behind the visual.  Copy the DAX query, and use this in DAX Studio to return the data behind the visual.  This is also quite handy when writing documentation.

 

 

In this case, the DAX expression would be :

 

// DAX Query used by Table Visual to return Gross Sales column data
DEFINE
    VAR __DS0Core =
        DISTINCT ( 'financials'[Gross Sales] )
    VAR __DS0PrimaryWindowed =
        TOPN ( 501, __DS0Core, 'financials'[Gross Sales], 1 )

EVALUATE
__DS0PrimaryWindowed
ORDER BY 'financials'[Gross Sales]

 

 

Follow Gilbert Quevauvilliers post from June 2022 for general instructions.

  • Sukhraj_Ghuman's avatar
    Sukhraj_Ghuman
    Regular Visitor
    2 years ago

    Hi, thanks for the response and it's working but i cant extract all the rows in the table but the only thats visble in the table, why's that? 

    I tried to extract 4577 rows but only 500 is extracted in the CSV file.

     

     

    Thanks for the quick response!!

     

    • foodd's avatar
      foodd
      Community Champion
      2 years ago

      Hell Sukhraj_Ghuman, if I understand you correctly, I believe that you are referring 

      to when you preview a table in DAX Studio it uses TOPN to limit the display  to

      the top 500 rows.

       

      // Generated DAX Query to display top 500 rows of 'Table 3'
      EVALUATE 
      TOPN( 500, 'Table 3' )

      // DAX Query to display all rows of 'Table 3'
      EVALUATE 'Table 3'

      • Sukhraj_Ghuman's avatar
        Sukhraj_Ghuman
        Regular Visitor
        2 years ago

        Ok, thanks.

        I tried and its working just fine.

        Thanks a lot! And have a great day!

  • bmacknz's avatar
    bmacknz
    Advocate I
    2 years ago

    what are the next steps in this process?   I've managed to follow these steps and get query results but can't figure out how to get those results into a .csv  or .xls file.  the only way to export the results I see is trying to export a table, not the query results and if I select export metrics then I get a .vpax file and I'm not sure what to do with that