•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Power Query maintains filter in data table
Hello,
I am currently using power query to transform a data table (with several users) into a data model for reporting. The data is stored as a table and referenced with power query.
My issue is that power query seems to keep the filters applied I or other users are using for working with the table. So when I update the reporting and forget to remove all table filters, the reporting will be wrong. I never noticed that before when working with power query. Is that standard behaviour? Is there a way to bypass that behaviour so power query is always using the full table?
Thank you very much in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site