question

ramniwas-6911 avatar image
0 Votes"
ramniwas-6911 asked emilyhua-msft answered

Access web content could not authenticate in excel 2019 power query

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


power-query-not-supportedoffice-excel-itpro
excel-error.png (97.5 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

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@ramniwas-6911
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.

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.