Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Laura_Dannisoe
Frequent Visitor

Expression.Error: 1 argument was sent to a function, which expects 2

Hello community!

 

I am getting this error: 

Expression.Error: 1 argument was sent to a function, which expects 2.

Details:

Pattern=

Arguments=[List]

 

This is the power query:

Laura_Dannisoe_0-1611656328395.png

 

Can anyone help what to do? 🙂 

Thank you very much!

 

 

1 ACCEPTED SOLUTION

Hello @Laura_Dannisoe 

 

is this your function "SinglePageMB"? As I can see it needs two parameters, but you are launching it with only one.

Jimmy801_1-1611660743527.png

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

 

View solution in original post

4 REPLIES 4
Jimmy801
Community Champion
Community Champion

Hello @Laura_Dannisoe 

 

two things that come into my mind here:

Jimmy801_0-1611658709863.png

Is Record.Field returning a list to count? In other words, is the record "StartRecord" containing fields that contains list where you can count items?

 

You are using a few custom functions. Maybe here you forgot to add a parameter

Jimmy801_1-1611658797446.png


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

Hi @Jimmy801 !

 

Thanks for your answer. 

Yes it is returning a list of items.

 

I have checked the custom method and when I am calling it, it seems to work correct. This is the query for that method:

Laura_Dannisoe_0-1611659375841.png

 

Do you have any ideas of what I can try?

 

Best,

Laura

 

Hello @Laura_Dannisoe 

 

is this your function "SinglePageMB"? As I can see it needs two parameters, but you are launching it with only one.

Jimmy801_1-1611660743527.png

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

 

Ah just noticed that the name of the function was "SinglePageMB (3)" and it thought the "(3)" was a parameter. It is working now, thank you! 

 

Have a great day 🙂 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.