DM_GWPipeline_Gateway_MashupDataAccessError

Hi,

I got a similar error as below. I changed the privacy level, but I could not find any solution. I think the error is with the record, as mentioned. It is strange, because in the desktop is ok, but in the power bi service, I face this issue. I tried to remove some steps from my query, and it works, so I think the error is in a step of my query that uses a function. I haven't managed to solve it after hours. If someone has had a similar experience with a function, I would appreciate any tips you may have. many thanks

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":"We cannot convert the value \"[Record]\" to type List."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10277"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: ACCA.
Cluster URI: WABI-NORTH-EUROPE-O-PRIMARY-redirect.analysis.windows.net
Activity ID: acbfee22
Request ID: b2ab10c3
Time: 2025-08-20 12:27:57Z