cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pbi101
Frequent Visitor

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

1 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

 

View solution in original post

4 REPLIES 4
Anand24
Super User II
Super User II

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
Frequent Visitor

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.

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

 

View solution in original post

Thanks!  Removed the type and it worked.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.