Forum Discussion

pbi101's avatar
pbi101
Frequent Visitor
6 years ago
Solved

Refresh Error in PowerBI Service. No issue refreshing in Desktop

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

4 Replies

  • Anand24's avatar
    Anand24
    Super User
    6 years ago

    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 !!!

    • pbi101's avatar
      pbi101
      Frequent Visitor
      6 years ago

      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.