Invalid connection credentials

[Anonymous]

Hi all,

I cannot refresh my report into PowerBI.com, I have this error message : 

"Something went wrong
Invalid connection credentials.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259 Table: full_export_survey.
Underlying error message: The credentials provided for the Folder source are invalid. (Source at \\sw00q584\app-power-bi$.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: Folder
Microsoft.Data.Mashup.CredentialError.DataSourcePath: \\sw00q584\APP-POWER-BI$
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Folder","path":"\\\\sw00q584\\APP-POWER-BI$"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 20625d68-75bf-4de2-83c0-f7c73e76fbb9
Request ID: 81d46b09-4886-837b-35f2-0aeae01b7e83
Time: 2019-07-02 10:51:39Z "

But when I am in Power BI Desktop I have no problem with my credentials to made refreshs.

I am not in charge of the gateway but the person who is in charge of it said me that there is no change on their side.

Can you help me on that point ? 

[luisrh]

It depends where you are sourcing your data into power bi from.  I have seen this work fine in PBI desktop and not on the service when the service account running the gateway does not have access to the folder the file that sources your data is.   This usually happens with Excel or csv based data sources.

Hope this helps.

If this helps, please mark as resolved to help other users get the answer.

thanks.

[Anonymous]

@luisrh Thanks for your reply. So, what can I do to resolve this ??

[luisrh · Accepted solution]

As I mentioned.  If the source for your data is an excel file , csv file or something stored on disk,  the service account that the Gateway is running under should have access to that share.   Usually,  the best way to do this when using gateways is to have a central share where you store files that Power BI uses to refresh its datasets.