Refresh failing in Power Bi Services but working in desktop version with out any issue

[dw700d]

I scheduled a refresh for my dashboard in power bi services but the refresh fails and I get the following error below. Can anyone help me understand what is going on and how to fix it?

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":"Oracle: ORA-00942: table or view does not exist"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"p1fdw2d2"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ORA-00942: table or view does not exist"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: QOZ Table(Inclues SCM & Vendor Rule identifier).
Cluster URI: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID: c9fb284d-b549-4041-b6c3-f4e4801f32ed
Request ID: 6ddb7565-af26-a6e5-45ad-9ad82f45e0ea
Time: 2022-10-27 12:59:45Z

[wikkleyn]

Hi @dw700d Does the user used in the Gateway Connection have access to all the tables in the dataset?

[v-binbinyu-msft]

Hi @dw700d ,

Please try below steps:

1. Make sure your data source still exists and no change in credentials

2. Make sure the firewall has no restrictions

3. Update or restart the gataway ,or restart the machine that host the gateway

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.