•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
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