Forum Discussion

amalm's avatar
amalm
Icon for Helper III rankHelper III
6 years ago
Solved

Major bug in Excel Powerquery (Get & Transform) for dates

My query data is from another excel file. The source file is updated on a daily basis with new records, and I need the query file to transform that data and present it in a proper format.    There ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi amalm ,

     

    I suspect this may not be so much PQ issue. This looks more like a table/cells formatting issue in Excel itself.

    Could you please try:

    1. Format the entire column to "Short Date" format. Not just a column in the table, but the entire column in Excel (like "H").

    2. If this does not help, delete the existing table from the file (better the entire tab/sheet) and re-export using Load-To or alike to a new tab?

     

    Kind regards,

    JB

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi amalm ,

 

I suspect this may not be so much PQ issue. This looks more like a table/cells formatting issue in Excel itself.

Could you please try:

1. Format the entire column to "Short Date" format. Not just a column in the table, but the entire column in Excel (like "H").

2. If this does not help, delete the existing table from the file (better the entire tab/sheet) and re-export using Load-To or alike to a new tab?

 

Kind regards,

JB

amalm's avatar
amalm
Icon for Helper III rankHelper III
6 years ago

Thank you so much! Your first point solved the issue I was beating my head over!

 

The thing is, the file had been in use for many months and everything was working fine earlier when the computer was on Office 2016. They recently installed Office 365 on it and this broke the file. Now it works fine again. 🙂