Relative Content

Tag Archive for cachingpowerquerydatamodelexcel-365

Can I force PowerQuery to clear the Data Model before refreshing?

I’m trying to develop an audit tool to track changes in our product library (bureaucracy prevents a better option) but when I refresh my live DB query and compare it to the previous copy, I notice the case had changed on some values but when I manually queried the data in SSMS, the case had not changed. Example: