I am new to PowerQuerry. I am connecting to our accounting database via OData. PowerQuerry loads the table just fine, and I am able to apply several different filters, and inside Querry Editor I see the records being filtered, but when I close and load into Excel it returns 0 records.
I noticed that some filters result in this behavior and some do not. For example, I have one column called year, if I filter on it, querry editor displays the records in the editor and when I close and load I see results in my table in Excel. However, if I choose a different column for example Department, and filter on that, querry editor displays the appropriate filtered records, however when I close and load my table in Excel displays 0 records.
I noticed that some filters result in this behavior and some do not. For example, I have one column called year, if I filter on it, querry editor displays the records in the editor and when I close and load I see results in my table in Excel. However, if I choose a different column for example Department, and filter on that, querry editor displays the appropriate filtered records, however when I close and load my table in Excel displays 0 records.
