nathank
New Member
Hello to all,
I'd like to tell you about a problem I'm having when loading data from an xlsx file (located on a sharepoint), via power query, from a data stream.
I have deactivated the data type recognition on power query but when I load the file, I notice a difference between the date data (see attachments). On the one hand, on the xlsx file, the dates appear as "yyyy-mm-dd" and on power query, a number that does not seem to be the subtraction of these numbers appears. I would like to point out that the date data in the xlsx file is of the "general" type.
I note however that the problem is solved when I recognize the columns under the date format on the xslx file directly, but this is not a viable solution because it is a file from an external source, there are many files downloaded daily, which would represent a very big waste of time.
Does anyone have an idea where the problem comes from and how to solve it?
ps : sorry for my english
I'd like to tell you about a problem I'm having when loading data from an xlsx file (located on a sharepoint), via power query, from a data stream.
I have deactivated the data type recognition on power query but when I load the file, I notice a difference between the date data (see attachments). On the one hand, on the xlsx file, the dates appear as "yyyy-mm-dd" and on power query, a number that does not seem to be the subtraction of these numbers appears. I would like to point out that the date data in the xlsx file is of the "general" type.
I note however that the problem is solved when I recognize the columns under the date format on the xslx file directly, but this is not a viable solution because it is a file from an external source, there are many files downloaded daily, which would represent a very big waste of time.
Does anyone have an idea where the problem comes from and how to solve it?
ps : sorry for my english