Forum Discussion
Dates import as Null while Querying from Sharepoint folder
I have an xlsx file in a Sharepoint folder and I create a query to import it to Power Bi. It has several date columns but they all show up as having null as the value. If I open the file the dates ar...
Syndicate_Admin
Administrator
AdministratorGood! Did you solve the problem? The same thing just happened to me and I think it's not a problem of the file being in Sharepoint or a local folder. In my case the problem was that the excel format, although it was xlsx, the file type was "Strict OpenXML spreadsheet (*.xlsx)". As soon as I changed it to "Excel workbook (*.xlsx)" it has already recognized the dates without any problem.