scheduled refresh - credential

[bbbbbiiiii]

Hi all

I am facing this error. I have sign in the credential (from the Data Source credential). But i still faced this error when i did the scheduled refresh. Can help? Data source: sharepoint online list

Underlying error code: -2147467259 Table: Table_query.
Underlying error message: Credentials are required to connect to the Web source.

Microsoft.Data.Mashup.MashupSecurityException.Reason: CredentialMissing
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 728f738f-852a-4bd4-8589-b984d05d2695
Request ID: 75b51a89-4523-4ac7-810d-ee466a50853f
Time: 2020-01-02 09:01:44Z

[v-lid-msft]

Hi @bbbbbiiiii ,

Sorry for that , But we cannot reproduce this issue on my side. What is the Authentication method you used for this dataset? Could you please try to refresh the data in the Power BI  Desktop with the same credential? Have you tried to do a on-demand refresh? 

Sorry for any inconvenience this issue have caused.

Best regards,

[bbbbbiiiii]

@v-lid-msft, i used the same configuration as your screenshot. I have tried to refresh the PBI Desktop and it shows no errors.
@SivaMani, the data source credential settings look ok. There isnt any "cross" mark besides the source.

[bbbbbiiiii]

this is the screenshot of the error i got from pbi online.

[v-lid-msft]

Hi @bbbbbiiiii ,

Are there any other data source in this dataset rather than SharePoint Online List? Are you using the build-in SharePoint Online List Connector?

Best regards,

[bbbbbiiiii]

@v-lid-msft 

This is my data source settings. Pls guide me if there is another way to do it? Thank you

[v-lid-msft]

Hi @bbbbbiiiii ,

Could you please try to connect the SharePoint Onlist with the build-in connector from Get-Data? Please refer to this document to get more information: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-sharepoint-online-list

Best regards,

[bbbbbiiiii]

@v-lid-msft I recalled why I use a web source. I could not connect to the sharepoint online list. This is the error.

However, I am not the administrator for both PBI and sharepoint. Can anyone share with me what is wrong with this error and any solution to it?

[v-lid-msft]

Hi @bbbbbiiiii ,

Seems like your URL is not correct. Are you using the '.aspx' link from sharepoint. Could you please try to  trimmed down the end as following?

https://COMPANYWEBSITE.sharepoint.com /SitePages/Home

Please also refer to this similar thread:https://community.powerbi.com/t5/Desktop/Connecting-to-a-SharePoint-List-Office-365-error/td-p/10075

Best regards,

[bbbbbiiiii]

@v-lid-msft I dont have the access: Details: "Access to the resource is forbidden." 😅

[SivaMani]

@bbbbbiiiii,

Can you check the data source credential setting and make sure that you provided credentials for all the available connections, Please?