Forum Discussion
Refresh Error on Power BI service
Hello All
I have a report which is refreshing fine on Power BI desktop. However, it fails when I refresh on Power BI service.
My report is using SQL Server database and sharepoint as sources.
This has been happening from past few days.
Below is the error I get -
{"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.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Value","detail":{"type":1,"value":"[Record]"}}],"exceptionCulprit":1}}} Table: Table1.
Does anyone know of any known issues related to this?
Or has faced anything similar?
Regards
1 Reply
- nickyvv
Most Valuable Professional
The error message says
"We cannot convert the value \"[Record]\" to type List." Somewhere in Power Query a List is expected, but a Record is provided.
Can you show us (or tell if you can't share the M code) the Power Query steps that were taken?