Getting this error while syncronizing documents using Power Query..

Neff, Gail 1 Reputation point
2021-08-12T18:57:52.9+00:00

122759-error-script-2.pdf

No idea how to fix this. Trying to help a few end users at remote location. I need to know what needs to be done to fix this.
After trying to link documents from either the local drive and One Drive---errors happens.
First, the "Unexpected Error", then after hitting Copy Details you have to paste it into a Word document then just more errors and then that 18 page script error I attached to this. Please please help asap. Does this mean it is corrupted? Does something need to be deleted? It is happening to 4 people at the same location. The IT tech can do it with no errors onsite. Excel was restarted and same errors.122826-ticket-27673-excel-screenshot.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,595 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,620 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Miguel Escobar 326 Reputation points
    2021-09-06T02:34:51.147+00:00

    Hey!
    Do you have a way to repro this situation on my end? It's difficult to pinpoint exactly what's happening with the information provided, but here's a few things that you could try to check:

    1. Check if the query *ies) in the Power Query Editor refreshes and if you get a data preview.
    2. Check if the privacy levels of your queries might get in the way and perhaps disable the privacy levels on their machines.
    3. Do those machines have an older version of Power Query and you had a newer one? There might be compatibility issues if you created the query with a newer version, of perhaps there's a bug with the version that they have that was fixed in a later version (like the one you're using)
    4. Have you been able to pinpoint what are the differences between the environments so you can repro the errors on demand even on new machines?
    0 comments No comments