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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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