cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ncbshiva Member
Member

Refresh failed in the Power BI online

Hi Team,

 

In my report , i am using SharePoint and SQL Datasource and i am using gateway to refresh the data in the SQL . But the refresh is failing with below error message. Not sure why the refresh is failing . Can anyone please let me know where is the problem occurring for this refresh in the online.

 

Underlying error code:-2147467259 Table: Strain.
Underlying error message:The credentials provided cannot be used for the SharePoint source. (Source at https://xxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxx.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourcePath:https://xxxxxxx.sharepoint.com/sites/xxxxxxxxxxx
Microsoft.Data.Mashup.CredentialError.Reason:CredentialInvalid
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"SharePoint","path":"https://xxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:CredentialInvalid
Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:0ddfae4e-b115-4727-bf8a-3cf59f492218
Request ID:6cb808d2-9d5c-8da2-674c-8a684c64b302
Time:2019-01-02 16:28:35Z
8 REPLIES 8
ncbshiva Member
Member

Re: Refresh failed in the Power BI online

Hi Team,

 

Can anyone please help me to resolve this issue ?

 

Regards

 

eddydm Member
Member

Re: Refresh failed in the Power BI online

Our problem (in november 2018) has been solved by an update by Microsoft.

 

A collegue has told me there seems to be a limit at the number of documents in a sharepoint site that PowerBI can address.

His solution was to split the documents in different document libraries. We didn't tried this solution because our problem was already solved. (our post)

 

ncbshiva Member
Member

Re: Refresh failed in the Power BI online

But i have another report where i have more than 25 files in the Sharepoint which refreshes in Power BI online successfully in 25 minutes. 

v-yulgu-msft Super Contributor
Super Contributor

Re: Refresh failed in the Power BI online

Hi @ncbshiva,

 

As the error message prompted, please verify that if the credential specified for SharePoint source is correct and still valid. Also, please test whether it can refresh the dataset successfully in desktop version.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ncbshiva Member
Member

Re: Refresh failed in the Power BI online

Hi @v-yulgu-msft,

 

I have verified the credentials , it works when i have less number of files in the Sharepoint (like 5 files). But the online refresh fails when the number of files is more than 5 in the SharePoint. And the refresh works fine in the Desktop version regardless of the number of files in the SharePoint.

 

Regards

 

v-yulgu-msft Super Contributor
Super Contributor

Re: Refresh failed in the Power BI online

Hi @ncbshiva,

 

Did you use On-Premises gateway personal mode and choose OAuth2 as authentication type in your scenario?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
ncbshiva Member
Member

Re: Refresh failed in the Power BI online

Hi @v-yulgu-msft,

 

Please find below screenshot of the gateway that i am using , it is not Personel mode. And i have authenticated with OAuth2 type.

 

Pic.png

v-yulgu-msft Super Contributor
Super Contributor

Re: Refresh failed in the Power BI online

Hi @ncbshiva,

 

I would suggest you create a support ticket for further analysis, as all configurations looks correct and the scheduled refresh should work.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 53 members 856 guests
Please welcome our newest community members: