Hello,
After updating one of my Tables and refreshing all, power query and the data model shows the correct number of rows and everything but different contents in one of the columns than what Is actually listed in that column from my ‘Table’ (external data source). It happens to be a column for the Year that gets entered manually. 2021 is in the entire column and power query and data model shows 2020!? It’s not detecting for some reason. Has ever happened before?
Thank you
Hi Jen,
I'd need to see the file or at least screenshots that document the entire data flow.
Mynda
I corrected this in power query by duplicating the date column, then extracted the year and replacing this New column as my Year column so that my slicers work. All okay now. Thank you.
