Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
2 years ago
Solved

Query not refreshing on a full refresh

 

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

  • Found it. In Power Query Editor. Include in report refresh isnt ticked for this dim so i can sort this out

1 Reply

  • DebbieE's avatar
    DebbieE
    Community Champion

    Found it. In Power Query Editor. Include in report refresh isnt ticked for this dim so i can sort this out