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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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?

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
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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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