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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ribeirocr
New Member

Issue with Power BI Dataflow - error "2 arguments were passed to a function which expects 1"

Hello,
I'm working on a dataflow that it is connected to dataverse. This connection is simple, but I don't know why I'm getting this error:

ribeirocr_0-1737039970736.png

 

This is the power query code I'm using:

ribeirocr_1-1737040030509.png

The strangest thing is that the dataflow refreshes with no issue, but when I enter on edit mode, it gives this error. I've tried to create a new dataflow with the same connection, and it works, but when I try to add transformations, it gives the same error. 

 

Can someone help?

1 ACCEPTED SOLUTION
v-nmadadi-msft
Community Support
Community Support

Hi @ribeirocr,
Thanks for reaching out to the Microsoft fabric community forum.
 Please try these troubleshooting steps and check if you are able to bypass the error

1) To use the Dataverse connector, the TDS endpoint setting must be enabled in your environment. For Reference: Manage feature settings - Power Platform | Microsoft Learn

2) To use the Dataverse connector, one of TCP ports 1433 or 5558 need to be open to connect. Port 1433 is used automatically. However, if port 1433 is blocked, you can use port 5558 instead. To enable port 5558, you must append that port number to the Dataverse environment URL, such as yourenvironmentid.crm.dynamics.com, 5558
Power Query Dataverse connector - Power Query | Microsoft Learn

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to give "Kudos"

Thanks and Regards

View solution in original post

4 REPLIES 4
v-nmadadi-msft
Community Support
Community Support

Hi  @ribeirocr ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Thanks and regards

v-nmadadi-msft
Community Support
Community Support

Hi @ribeirocr ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thanks and Regards

 

v-nmadadi-msft
Community Support
Community Support

Hi @ribeirocr 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-nmadadi-msft
Community Support
Community Support

Hi @ribeirocr,
Thanks for reaching out to the Microsoft fabric community forum.
 Please try these troubleshooting steps and check if you are able to bypass the error

1) To use the Dataverse connector, the TDS endpoint setting must be enabled in your environment. For Reference: Manage feature settings - Power Platform | Microsoft Learn

2) To use the Dataverse connector, one of TCP ports 1433 or 5558 need to be open to connect. Port 1433 is used automatically. However, if port 1433 is blocked, you can use port 5558 instead. To enable port 5558, you must append that port number to the Dataverse environment URL, such as yourenvironmentid.crm.dynamics.com, 5558
Power Query Dataverse connector - Power Query | Microsoft Learn

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to give "Kudos"

Thanks and Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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