Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Cannot convert a value \"[Record]\" in type List

Hi, i'm having the following issue when trying to refresh my report:

{"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":"Não conseguimos converter o valor \"[Record]\" em tipo List."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Value","detail":{"type":1,"value":"[Record]"}}],"exceptionCulprit":1}}}



It refreshes fine at Power BI desktop, and the Power BI service doesn't provide me the name of the table that causes the problem. I also couldn't find it using the ODGLogs, since it states that the error was outside the Gateway.

How could I troubleshoot it?

Community Support
Community Support

Hi @LiviaAraujo ,


Please refer to the case.

Publish dataset from desktop reports success but error in service - key didn't match 


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors