Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Team,
I am getting this error "Unexpected error: Operation is not valid due to the current state of the object".
What am I doing?
1. we created a function which needs 2 parameters - 1st parameter is Jira API URL & 2nd parameter is Project Key both have type = text
2. Now we have a table that contains 2 columns - 1st column is JIRA API and 2nd columns is ProjectKey. both have type = text
3. Now we call the function and pass the column values as parameter but it gives above error.
4. So now instead of column values we tried passing the values Hardcoded values and now it returns a table - means it is working.
5. Why it is not working we pass the column name as parameter to the function?
6. We need this as we have to call this function for each row of that table.
Solved! Go to Solution.
Hi,
Finally, I found the solution to this issue.
for example: below is my function
fn_function = (a as number) =>
let
a = a
in
a
now here since on both the side we have the same variable name. it gives the error. so I changed the function to below:
fn_function = (b as number) =>
let
a = b
in
a
then the issue got solved.
@Anonymous
Glad you found the solution yourself. And Thank you for share it.😀
Paul Zheng _ Community Support Team
Hi,
Finally, I found the solution to this issue.
for example: below is my function
fn_function = (a as number) =>
let
a = a
in
a
now here since on both the side we have the same variable name. it gives the error. so I changed the function to below:
fn_function = (b as number) =>
let
a = b
in
a
then the issue got solved.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 16 | |
| 14 | |
| 14 | |
| 10 | |
| 9 |