Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
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.
I do not know HOW to fix this 😞
Please help.
@Anonymous
You may check if column names are exactly matched.
The columns names match.
I also copy and paste table headers as a option but this did not fixed it. 😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |