Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @dw700d Does the user used in the Gateway Connection have access to all the tables in the dataset?
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.