Access web content could not authenticate in excel 2019 power query

ram niwas 1 Reputation point
2021-03-27T11:05:40.88+00:00

82063-excel-error.pngwhile i am connecting through data tab > get data > from web in excel 2019 power query an error occurred "We couldn't authenticate with the credentials provided. Please try again" whereas i am selecting Anonymous. please help on this issue

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,949 questions
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,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-03-29T06:23:33.293+00:00

    @ram niwas
    Was the previous connection to this URL successful?

    It's recommended to clear existing permissions to have a check via going to Data > Get Data > Data Source Settings > Global permissions > click “Clear all permissions to remove all permissions”.
    Then try to connect to this web content again.

    I would also suggest you go to File > Options > Data, then tick the box of "From Web (Legacy)" to enable legacy data wizard.
    Then please go to Data > Get Data > Leagcy Wizard > From (Web Leacy), contect to this URL.
    More detailed information, please refer to "Data import and analysis options".

    Any updates, please let me know.

    If an Answer 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.

    0 comments