I have an excel workbook with a query. The workbook is in a folder on One Drive. I can run the query just fine from my computer. One of my co-workers can run the query just fine from their computer. But another co-worker can't run the query, it gives them an error:
I tried deleting this transformation and the next transformation was also giving an error. I tried deleting that one as well and the next transformation also gave the same type of error. Not sure why this is happening.