Forum Discussion

v-lpathak's avatar
v-lpathak
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Power BI export to excel

Hello there, On Power BI service published report (https://msit.powerbi.com/). Whenever I am exporting my table visual's data to Excel. The date in the excel shows 1900 as a year for all dates. Sha...
Need Help
v-lpathak's avatar
v-lpathak
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Hi Bryan,

 

For all the visuals in PBI we need to choose “Summarized data” option instead of “Data with current layout”.

The summarized data will give you the formatted output with all the columns as is. However the data with current layout will export the underlined data and especially with the table visuals with date it mess up.

 

You can turn on/off these options with the Report setting in your pbix report file.

 

Screen shot for the option to choose -

 

Thanks

 

datawizardry's avatar
datawizardry
Frequent Visitor
4 years ago

v-lpathak 

 

Where is the option to keep "Summarized data" enabled but disable "Data with current layout"? None I've tried work.

 

Currently I only see these options:

 

The last one disables it by greying out the export option entirely. Otherwise it always shows up as an option.


The other problem with the "data with current layout" export option that I noted in another thread is it doesn't keep the same layout order as the visual. It seems to be exporting the column order in the order that they are loaded to the visual. If you rearrange them after the fact, it won't export that way. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi,

    Where can i turn on or off other options. Can you please help me.