question

DavidJenkins-7665 avatar image
0 Votes"
DavidJenkins-7665 asked emizhang-msft commented

How do you use the WebAPI login?

I'm trying to learn how to setup WEB API authentication. Any articles would be helpful. I might be trying to do the wrong thing.

I would like to use Odata connections in Excel and have them refresh. I get errors when I do. I thought that it was permissions since the Excel app isn't logged in as anyone during the refresh.



133165-image.png


office-excel-itpro
image.png (18.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @DavidJenkins-7665,
I suggest you refer to these links and check if you can get any help from it:

https://stackoverflow.com/questions/33225590/authenticating-with-excel-power-query-against-net-odata-web-api
https://docs.microsoft.com/en-us/powerquery-m/odata-feed


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DavidJenkins-7665,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·

I haven't had time to come back to it. I'll test soon.

0 Votes 0 ·
emizhang-msft avatar image emizhang-msft DavidJenkins-7665 ·

Any updates you can post here, we are glad to help you.

0 Votes 0 ·