Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

simonmeacher

Date format on export

Submitted by on ‎01-13-2017 01:47 AM

I have a data table, that includes a date column.

 

The column is not always populated, in this case the column is formated as a decimal number , typical of a date in number form.  

 

Example of the column when opened in Excel.

Partly populated.PNG

 

If the column is completely populated, then the column is correctly populated.

 

Example of the column when opened in Excel

Completely populated.PNG

 

Is the formatting controled by Power BI or Excel?

 

thanks, Si

Status: Needs Info
See more ideas labeled with:
7 Comments (7 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎01-16-2017 06:10 PM

@simonmeacher

 

Can the date column be shown properly in Power BI Desktop before you export it? Do you repro this issue intermittently? I just try to repro it locally but has no success. Could you please provide your PBIX file to me? You can upload it to online file service like OneDrive and share it.

BTW, you can check the Cancel Date column format in excel, it is Custom in the exported file in my side.

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎01-16-2017 06:11 PM
Status changed to: Needs Info
 
simonmeacher
Regular Visitor
‎01-16-2017 11:31 PM

Is there a way i can mask the data? I have client sensitive data that I cant release outside of the firm.

 

I know this is an option in other data presentation software.

 

regards, Si

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎01-17-2017 09:52 PM

 

@simonmeacher

 

Maybe you can try with following site to create dummy data for your data source. Then have a try to see if you can repro the issue with these dummy data. If yes, you can share your PBIX file to me with no sensitive data.

 

https://www.mockaroo.com/

 

Best Regards,

Herbert

 

simonmeacher
Regular Visitor
‎01-25-2017 01:07 AM

Hi,

 

I have tried to recreate the following, taking the data from a excel file. However, I can not replicate the issue.

 

I have returned to my orginal PBIX file, and can confirm that the column's data type is set as a Date/Time as is the column in the underlying SQL table.

 

I have scrambled the data within the table & reloaded. The file is available here

 

Regards, Simon

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎02-02-2017 07:07 PM

@simonmeacher

 

I’ve tried to export data from the table visual in your PBIX file several times. And I can always get the correct Cancel Date format in my Excel 2016.

Maybe you can try on some other machines which have different excel version to see if it helps.

 

Date format on export_1.jpg

 

Best Regards,

Herbert

PowerBin
Regular Visitor
‎03-09-2018 01:34 PM

I am having the same issue. I use a matrix visual to show the data on Power BI but when it is exported the date format is changing to date-time format. I am using SSAS tabular model as the data source. I have verified that the date format is MM/DD/YYYY in the model.  Is there a way to fix this. 

 

Thanks in advance. 

PowerBin

Idea Statuses