Refresh Error in PowerBI Service. No issue refreshing in Desktop

[pbi101]

I get the following error while attempting to refresh the dataset in Power Bi Service.

I am using the August 2020 version of PBI Desktop. There is no error refreshing in desktop or while publishing the report.

How do we troubleshoot ?

Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code: -2147467259
Underlying error message: 5 arguments were passed to a function which expects between 2 and 4.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Arguments: {Table.FromRecords({}), "Index", 1, 1, number}
Microsoft.Data.Mashup.ValueError.Reason: Expression.Error
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: 
Request ID: 
Time: 2020-08-25 15:18:33Z

[Anand24]

Hi @pbi101 ,

The error "Underlying error message: 5 arguments were passed to a function which expects between 2 and 4." appears when you have passed extra arguments somewhere in the Power Query editor M codes.

Check this line in the error: Microsoft.Data.Mashup.ValueError.Arguments: {Table.FromRecords({}), "Index", 1, 1, number}

Seems like this is where the issue lies.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[pbi101]

Hi @Anand24,

I checked the code when I got the error. 
I have not used Table.FromRecords explicitly in any of the m queries in my report.
But, I have used Table.AddColumnIndex in two occassions.

From the name "Index" in the error message I think there is some issue with Table.AddColumnIndex which does not appear in PowerBI Desktop.

[v-deddai1-msft · Accepted solution]

Hi @pbi101 ,

Did you have steps like 

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

in your m query?

Try to use the following one:

= Table.AddIndexColumn(#"Changed Type", "Index", 0, 1)

and try again.

For more details, please refer to the similar post:https://community.powerbi.com/t5/Service/Unable-to-Connect-to-Data-Source-Undefined/m-p/1323849/high...

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

Best Regards,

Dedmon Dai

[pbi101]

Thanks!  Removed the type and it worked.