Forum Discussion
Export underlying data
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 :-(
Hi Anonymous
I am taking export operation from power bi service after publish the report from desktop, i have created matrix in desktop then i exported the data it is giving only summarised data, from power bi service if i export the data with underlying data option it is exporting data to excel file with 33 columns only, and i have around 50 columns in the table which i used for the report, my requirement is i need all the columns to be exported in the excel file from power bi service while exporting data, i am attaching screenshots of power bi service, desktop and excel file. Please check and help me out on this.export data from serviceexported file column count is 33desktop in the right you can find the table with around 50 columns
Thank you
Rajmohan
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 Zhang
Anonymous
Hi, When I am exporting underlying data then only 1 row i.e 'Total' row of the Matrix is getting exported but not the whole data. Can you tell me why it is happenning?
Hello,
I am try to export the data from Detail report in Power BI Services ," Underlying data" option grade out for one report rest of the report was able to export the data into excel.
Why only one report having an issue?
I noticed that when we export data from details report . other columns exporting into spreadsheet which are not part of the detail report
Hi,
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 :-(
Hi,
the information in the link below helped me to change from Measure to column and then I'm able to export data using the underlying option.
Hope that it helps you
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Hi
I am struggling with the same issue.
export to underlying data is grayed out and error message was that i dont have permissions.
is this something to do with Admin permissions?
Anonymous Sounds like it. Power BI tenant settings allow you to disable exporting data, you would need to speak with your Power BI or Office 365 admin to enable this for you if you needed it.
I am missing two of the three value columns that are present in the visual during export. The other visuals using the same tables are providing all the value columns during export.
Seems odd to me that the visual showing all the value columns is only exporting one, but the visuals only showing one value is exporting all of them.Anonymous Thank you for this valuable information! I have left a feedback ticket for the documentation which is lackign this information. It's important to understand when reviewing security!
Hello Lydia
I have kind of the opposite problem; I do not want users to export the underlying data from my tables/matrices.
Is there anyway to disable that option and allow exporting only summarised data?
Thanks
Panos
Hello Lydia
I have kind of the opposite problem; I do not want users to export the underlying data from my tables/matrices.
Is there anyway to disable that option and allow exporting only summarised data?
Thanks
Panos
