I have a power bi dashboard and the source is some Excel workbooks in different folders. In one of this folders I have 49 .xlsx table files with amount of 298 MB.
In this tables, there is 3 differents columns with date, as below:
But unlike this image above all this dates is NOT blank in the Excel workbooks. In my .xlsx files this dates are filled, I am able to refresh power Bi data and get NO errors, but in my power Query or power Visual in power Bi this data is BLANK and this occours just only with date columns.
The courious is this mistake does not happen in first 22 .xlsx files in my folder, just with the others.