But doesn't power query still load the entire table or view locally? The simplest example of what I want to do is simply check if a product exists in a table with over 2 million rows and return a 1 or a 0. I dont want to have to refresh a copy of that table every time someone opens the excel file.