Question

Excel Power Queries Do Not Work in New Infra RPA VM 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.

  • 2 March 2022
  • 1 reply
  • 3 views

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.


1 reply

Userlevel 3
Badge +7

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