Unable to refresh power BI in workspace

[AndrewHam]

Hi

I have a dataset where the datasource is in my computer.

However, I'm not able to refresh it in the workspace using scheduling but I can do it when using the power BI directly.

Not sure where is the setup issue. any advise is greatly appreciated.

Underlying error code: -2147467259
Underlying error message: The credentials provided for the File source are invalid. (Source at c:\users\andrew\onedrive - andrew\documents\service contract\service contract details.xlsx.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: File
Microsoft.Data.Mashup.CredentialError.DataSourcePath: C:\Users\Andrew\OneDrive - andrew\Documents\Service Contract\Service Contract Details.xlsx
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"File","path":"C:\\Users\\Andrew\\OneDrive - andrew\\Documents\\Service Contract\\Service Contract Details.xlsx"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized
Cluster URI: WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID: b2d75d4d-29fa-41ad-9d07-555207738b4d
Request ID: e50b9f2a-c90a-5d56-f3ac-41c4e8daf043
Time: 2023-01-04 03:09:08Z

[anilkumar-yadav]

Hi Team,

I am also unable to refresh my report on my work place.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"OleDb\",\"path\":\"provider=OraOLEDB.Oracle.1;data source=HCLTMFDB1N01.HCLT.CORP.HCL.IN:1521/MFAMPROD\"},{\"kind\":\"File\",\"path\":\"C:\\\\Users\\\\anilkumar-yadav\\\\OneDrive - HCL Technologies Ltd\\\\Desktop\\\\Dashboard\\\\Pending Dump.xlsx\"},{\"kind\":\"File\",\"path\":\"C:\\\\Users\\\\anilkumar-yadav\\\\OneDrive - HCL Technologies Ltd\\\\Desktop\\\\Dashboard\\\\HC.xlsx\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"PrivacySetting"}}],"exceptionCulprit":1}}} Table: Raw Data.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: e1e418c7-faa7-4093-b69d-7f0202376feb
Request ID: fcee9d3b-c4a6-dc0c-4262-2ee3e7b8840e
Time: 2023-02-22 12:16:59Z.

[d_gosbell · Accepted solution]

You are pointing at a file on your c:\ drive, the service will not be able to access that unless you setup a personal gateway on your computer. The other option would be to use a https:// path for the file instead of the local file path.