Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    nickyvv
    Icon for Most Valuable Professional rankMost 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?