I copied an old Power BI Report and gave it a new source. The new source has the same columns but updated data. The Map of the USA on the NEW PBI report I made does not change the values by state, it gives it to max value, i.e. all the states say 4,100 instead of different number. The filters all match, what else should I check?

CodePudding user response：

If you "replace" a query by another one with the same name, the data model will be broken. What you need to do is "edit" an existing query and "paste in" the new code. You can do that by opening both queries in the PQ Advanced Editor. Of cause the new code has to result in the same column structure.