How do you use the WebAPI login?

David Jenkins 946 Reputation points
2021-09-17T17:34:28.127+00:00

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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor
    2021-09-20T07:36:47.517+00:00

    Hi @David Jenkins ,
    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://learn.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.