Refresh error

[IanCockcroft]

Hi guys,

I am getting an error on a refresh. On desktop,` I dont get  the error.

I cannt work it out.

any idea what this means

{"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":"5 arguments were passed to a function which expects between 2 and 4."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Arguments","detail":{"type":1,"value":"{Table.FromRecords({}), \"Index\", 0, 1, number}"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: All Exceptions.
Cluster URI: WABI-NORTH-EUROPE-E-PRIMARY-redirect.analysis.windows.net

thanks guys

Ian

[VijayP · Accepted solution]

@IanCockcroft 

https://community.powerbi.com/t5/Service/Index-column-breaks-Gateway-refresh/td-p/1239773

check this old blog item

[IanCockcroft]

Thanks Vijay,

fixed.

I changed the Add Index step in power query from

= Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type)

to

= Table.AddIndexColumn(Source, "Index", 0, 1)

works

thanks

[VijayP]

@IanCockcroft 

Great Thanks

Also please visit my Channel www.youtube.com/perepavijay and

www.perepaedu.com