I have created Power BI report with, SAP S/4 HANA CDS view as datasource.
The refresh works fine with Power BI Desktop. But when the report is published to Power BI Service getting the below error.
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":"Native queries aren't supported by this value."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"#table({\"Name\", \"Data\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Query_2.Cluster URI:WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.netActivity ID:47fa2d11-684d-447b-b6a0-168390aa7678Request ID:acbeff88-cf11-2ddf-ae1c-0008409c2c3dTime:2023-08-28 11:45:12Z
When searched for the solution on community - one solution suggesting for changing the privacy level of data source to "Organization" while other solution suggests for "Public" . Tried both but still same error continues.
Please suggest the solution for the above mentioned issue.
