Forum Discussion
Excel data changing format upon upload
Looking at your code, I see that your Excel Import includes Kind = Sheet. If you have this in Table format in Excel, then you can change that code to Item = "Table Name", Kind = Table]. If your data is not in table format in excel, then you can turn it into a table by selecting the excel table and pressing CTRL+T. If the info is in this current workbook, then Get data from Table/Range will do this automatically. Honestly, though, I never considered whether or not coulmn names respect date formats or data types.
Wait though, can[t you make these columns type text, and then promote headers? Once you do that, and then promote headers, you cna always go back and change the type.
--Nate
theres values on the first row and columns, just not showing in the croped images, like 5 columns with other information on the header that isnt dates, changing the data to type date, changes the values in the others rows, but on dataflows doesnt work the values comes changed even before promoting headers. its like its autoapplying a culture parameter when importing the file on the dataflow or promiting header on the power query desktop version, so would be a work around to avoid this upon data importing I guess?