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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#financial modeling with spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#natural language processing for spreadsheets
#rows.com
#Excel compatibility
#Power Query
#data table
#data model
#reporting
#filters
#transform
#users
#standard behaviour
#full table
#update