Sorry about the poorly worded title. I don't really know how better to explain it. I have a query in my database that compares results from a couple different tables and has 20 something columns.
When I try to bring the result into Excel by doing a Power Query within excel, it keeps telling me the table is blank but the column headers are correct. The query works fine in Access. There are some blank fields in the data which are expected.
When I change the Access query to make table and then bring that table in via Power Query from excel, everything works fine.
Is there a limit to the extent of an query I can bring in via excel that doesn't apply to tables? I'm not really sure how to get around this error other than make a new table from the database and then refresh the excel file.
I can post the SQL statement but I'd rather share it privately and it's pretty extensive.
Thanks.