Unable to refresh PBI service. "Error when processing the data in the dataset"

[bryanang]

Hi all,

Have configured my data gateway, nothing seems wrong when loading the dashboard on the PBI desktop. However, I can't refresh it on service, it returns the following error code. Please help.

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":"Could not find a part of the path 'Q:\\Singapore\\Depts\\Quality\\share\\QC_QA Updates\\QC Tier 1 Slides\\2023\\QC Tier 1 - New database.xlsx'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"Q:\\Singapore\\Depts\\Quality\\share\\QC_QA Updates\\QC Tier 1 Slides\\2023\\QC Tier 1 - New database.xlsx"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Uptime Nimbus.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 0ab28b79-a658-4d39-8914-4aa7600ac055
Request ID: 4c5f92f0-1736-8e7d-fbeb-b5cceb8fa322
Time: 2023-04-07 05:14:37Z

[lbendlin]

The gateway has no idea how to get to your "local" Q:  drive.  Place the Excel file onto an on-premise file share (with gateway connection) or on a Sharepoint (no gateway required)