1 min readfrom 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!

submitted by /u/chuki93
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article