Solved: Get Data - Web Source

sajithgh · ‎06-30-2021

Get Data - Web is not connecting now. It was working fine for December 2020 Version.

Now I am getting the below error for December 2020 Version.

Data Refresh error

May 2021 Version throws below error. The user credentials are correct. However it is not connecting.

v-luwang-msft · ‎07-01-2021

Try the following steps:

Please first go to Data > Get Data > Data Source Settings > Global permissions > click “Clear Permissions” , this will help to clear existing permissions to prevent the connection remembering any problematic credentials. Then try to connect again via Data > Get Data > From Online Services > From SharePoint Online list.

There are 3 options when you try to connect the site. Anonymous, Windows and Microsoft Account/Organization account. Please make sure you select “Microsoft Account/Organization Account” option > input the related username and password then click “connect”. Please make sure you are signing in with the account that have the permission to access the site. To check this, please use the account to access the list via browser directly, if the account can access this site list, then that means it has the correct permission.

If not work ,you also could try the below:

Step 1: import data source (again) from SharePoint as a SharePoint folder.

Step 2: go to Advanced Editor and copy data source code.

Step 3: go to your original table that points to the locally stored data source and replace the data source code with the new code.

Refer :

https://community.powerbi.com/t5/Desktop/We-couldn-t-authenticate-with-the-credentials-provided-Plea...

https://community.powerbi.com/t5/Desktop/Issues-connecting-to-sharepoint-credentials-error/m-p/19242...

https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-to-excel/028cf722-7d80-4b5a-882c-6...

Wish it is helpful for you!

Best Regards

Lucien

View solution in original post

v-luwang-msft · ‎07-01-2021

Hi @sajithgh ,

Try the following steps:

Please first go to Data > Get Data > Data Source Settings > Global permissions > click “Clear Permissions” , this will help to clear existing permissions to prevent the connection remembering any problematic credentials. Then try to connect again via Data > Get Data > From Online Services > From SharePoint Online list.

There are 3 options when you try to connect the site. Anonymous, Windows and Microsoft Account/Organization account. Please make sure you select “Microsoft Account/Organization Account” option > input the related username and password then click “connect”. Please make sure you are signing in with the account that have the permission to access the site. To check this, please use the account to access the list via browser directly, if the account can access this site list, then that means it has the correct permission.

If not work ,you also could try the below:

Step 1: import data source (again) from SharePoint as a SharePoint folder.

Step 2: go to Advanced Editor and copy data source code.

Step 3: go to your original table that points to the locally stored data source and replace the data source code with the new code.

Refer :

https://community.powerbi.com/t5/Desktop/We-couldn-t-authenticate-with-the-credentials-provided-Plea...

https://community.powerbi.com/t5/Desktop/Issues-connecting-to-sharepoint-credentials-error/m-p/19242...

https://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-to-excel/028cf722-7d80-4b5a-882c-6...

Wish it is helpful for you!

Best Regards

Lucien