Article

View and Export Data in Power BI Desktop


D-Katy | Posted on April 07, 20

  Sometimes in Power BI Desktop, you need to retrieve the dataset used to create a visual to analyze it or use it in another context. Power BI Desktop offers the possibility to view and export the data that was used to create a visualization as a .csv file, let's see how it works.

View the data

  1.  Select More actions (...) from the upper-right corner of the visualization.

   

  2.  Choose the Show as a table option.

   

  3.  Power BI will display the data as shown below.

   

 

Export the data

  1.  Select More actions (...) from the upper-right corner of the visualization.

  2.  Choose the Export data option.

  3.  Save the file. 

 

Notes

  • The maximum number of rows that Power BI Desktop can export to a .csv file is 30,000.
  • If the visualization is filtered, then the .csv export will be filtered as well.

 

Related Video:

 

 


(0) Comments

There is no comment

Leave a Comment

Your email address will not be published. Required fields are marked *

Add to favorite
Categories
Recent Posts
DAX Language - CONTAINS Function
A-Badde | May 09, 20

The CONTAINS function returns a boolean value, TRUE if each ...Read More


DAX Language - RANKX Function
A-Badde | May 05, 20

The RANKX function returns a single integer value that repre...Read More


DAX Language - AND and OR Functions
A-Badde | April 10, 20

AND/OR functions check whether all arguments are TRUE or one...Read More


DAX Language - Variables in DAX
A-Badde | April 10, 20

Use Var keyword to store the result of an expression as a na...Read More