Skip to main content

I have an excel file that has power queries on it and it is erroring out on the New Infra Dev and Prod VMs, but it runs fine on my local workstation.

Could you please try the below steps,

 

1. Go to PowerQuery File->Options and Settings->Data Source settings->Global Permissions. Delete the Global permissions and close the dialog boxes. Sing in with correct account then Refresh the file again.

 

2. Remove this query and online repair Excel. Then re-connect this query to check the result. (Apps&Features-> Office-> Excel-> Modify-> Online Repair. )


Reply