I have a Junk dimension with the column descriptors in there. Key 0 Group A and Key 12 Group B
You could see this in the backend Power Query Editor. So I do a few full refresh of the data (I have attempted a few full refreshes loading it back into the Power BI Front End)
and in the front end it shows Key 0 Group A and Key 12 Group A. Which doesn't match what I can actually see in power Query Editor. this then throws all my visuals out.
After being completely stumped as to why that was I individually refreshed the junk dimension and this time the refresh worked and now I have Metrics and Milestones in the matrix
So my question why didn't power BI refresh this dimension on a full refresh? Its really odd. if anyone can shed any light on this I would be greatful. Its really worrying if you assume things are refreshing and they aren't
