Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Include non-text type columns in data export from Power BI Service

Case: You have published a report to the Power BI service that has a Card visualization with the count of a certain column in your dataset You want to export the underlying data to xlsx (not the summarization data) from the Power BI Service/reports/visualization level, in order to get the "raw" data that is contained in the table that the Card visualization is using Currently, it seems that the underlying data export option does not include non-text type columns (ie. it doesn't export numeric or date type columns) This was validated in this post: http://community.powerbi.com/t5/Service/Export-underlying-data/m-p/109241#M17669 The workaround I found to be "working" is: for numeric columns, change default summarization to don't summarize for date columns, change format to text Not sure what these changes impacts other areas (measures or new columns that uses these source columns for calculations and stuff, like days between dates for example...will the calculation still work if they are text type? I didn't test...) Can you please make the non-text type columns available in the export option? Thanks
Status: Needs Votes
Comments
blecouteux
New Member
This is a great idea as for me changing the date type into text would break all date-related functions, and I do need all columns in my export
fbcideas_migusr
New Member
Status changed to: Needs Votes