Exporting Table doesn't export all columns

[RecycleBin_Rob]

Hi,

I inherited a PBIX to work on. I noticed that the published dashboard has 7 columns in a table (let's just say A to G). When I click on export, the resulting csv/excel file only shows columns C and E. I went back to the original Desktop version and when I export, it will export with all columns.

As I mentioned, I didn't create or publish the original dashboard, so I don't know if it is a permissions issue. Basically, I'm hoping to get some guidance on how to enable all columns to be exported. A follow up question would be (going forward), how do I control which columns from a table  will be exported if I don't want the entire table to be exported. I might just be using the wrong keywords in my search. Thanks!

[lbendlin · Accepted solution]

A table visual is not the same thing as a table. The table visual can combine data from multiple tables in your data model.  There are various export options that you can choose from on the service, or you can run your own DAX queries to get exactly the output format you need.