Forum Discussion
Excel .xlsx and .xls
Hi there! Someone can explain to me why when I'add an Excel file with xlsx extension PBI automatically detect the data type even if there's a mixture of data in the same column (Image 1). But ise...
This might be caused by the Access Database Engine.
https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites