Forum Discussion
Export underlying data
HI I am exporting underlying data from my report(Matrix), and i am getting the correct count of rows, but all columns are not included in the excel data, i wants to export the data with all columns ...
Hi Anonymous,
I got information that when using the “export underlying data” option in Power BI Service, the export file will contain columns which are used to create the visual together with all “Text” type columns. If you want to export all columns, you would need to set the rest columns to be “Text” type or include the rest columns in your Matrix visual.
Thanks,
Lydia ZhangHi,
I'm also having the same problem and from my side the issue is that I'm using a calculated measure and I'm trying to find some option to solve this but still no luck :-(
Try to change the datatype of the measures and lets try it, you'll get all the data