Hi! I've created a query that is dynamically linked to pull data from the most current version of the source file. I don't need to show rows 1 - 3, but I get an error that the column can't be found when I promote row 4 to headers. I removed top 2 rows, then used first row as headers. Not sure where I went wrong or what's causing the error. Could someone please help me fix this? Thank you in advance!
Source File: Data Sample.xlsx
Query let me update to the new source file Data Sample - Copy if I didn't make row 4 my headers.
Query gives me an error after cleaning up the report in PQ.
Source File: Data Sample.xlsx
Query let me update to the new source file Data Sample - Copy if I didn't make row 4 my headers.
Query gives me an error after cleaning up the report in PQ.