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.

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!

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    Should mention that in DAX Studio, if you look to Advanced > Export Data, you can dump one or more Tables from the local model without restriction.