In Power BI Desktop I have made changes in Power Query by Replacing Values in a column. Those changes correctly flow into the spreadsheet view, but when I go to edit the grouping of the column, the ...
jimgores
4 years agoAdvocate I
Sorry, I was not clear above. I created groups in Power BI desktop and then went into Power Query to do the Replace Values step, then I did Close & Apply to pull the changes back into Power BI. The changes appeared in the Data or Spreadsheet view for Power BI, but then when I went to Edit Group (in Power BI), the old data values were still loading even though they did not appear in the column. I tried refreshing multiple times and ways and then gave up. However, I walked away from it for about a half an hour and when I tried again, the correct data values loaded up. Not sure why there was such a significant delay.