Error When Refreshing PowerQuery On Other Computer in same Network

Question

I have a simple data transformation that I am doing to an Excel file in PowerQuery/Get and Transform that is saved on a network. The Get and Transform refreshes on my computer, but not on anyone else's computer. I have tried to find a solution online and it seems like the issue is with privacy settings or a bug in PowerQuery itself. In the transformation, I source the file from a csv on the network, promote headers, update the data types for the columns, filter the columns based on a named range I have in the underlying Excel file, and keep the first n number of rows where n is based on a named range I have in my underlying Excel file.

The error that comes up on other computers in the network is:

"Query 'Name of Query' (step 'AutoRemovedColumns1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."

What is the reason that this works on my computer but not on others in the network? Is there a way to fix this?

Answer 1

Dear KarmanX,

As the issue is related to that the error messages when refreshing Power Query on other computers not the original computer in the same network and we have a dedicated channel TechNet forum - Excel IT Pro Discussions coping with such issues and questions, I suggest you post a new thread there for expert help.

Here is a similar troubleshooting article provided by the engineers in the thread on that forum for your reference.

Power Query Errors: Please Rebuild This Data Combination

Thanks for your understanding.

Cliff