Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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 !!!
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
Thanks! Removed the type and it worked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.