PQ oData URL connection needs changed - won't work

[cwolfe11]

Have a customer who needs to change URL link in Excel 2013 using Power Query. I am not familiar with PQ.

They say the 2nd option isn't avail anymore when they click 'from other sources', then "from odata", a window pops up and apparently doesn't have the option they previously chose.

Think they need to change URL link but also need to change how they setup URL link and don't see that option anymore.

???

Any help is very much appreciated!

-CW

 

[scottsen]

I don't know -- however, I know how I would try to tackle this, which might help?

First of all, PQ is totally backed by a language. You can view the script under something like View / Advanced Editor. You will see the URL there and could certainly change it, but you will also see any options and might be able to tweak there.

You could also just recreate the connection steps in a new query... then copy and paste them from script to script.