Share via

Error When Refreshing PowerQuery On Other Computer in same Network

Anonymous
2019-10-04T15:36:24+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

1 answer

Sort by: Most helpful
  1. Anonymous
    2019-10-04T18:25:43+00:00

    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

    Was this answer helpful?

    0 comments No comments