Skip to main content
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.

  • March 2, 2022
  • 1 reply
  • 47 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

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+16
  • Most Valuable Pathfinder
  • 3276 replies
  • March 2, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings