Unable to link Dataverse and SQL Server tables within Dataflows

[Syndicate_Admin]

Hello!

I am trying to link a Dataverse table to a SQL Server table in a Dataflow Mashup. 

Dataflows which contain only Dataverse tables work fine. Dataflows which contain only SQL Server tables work fine. So I am confident there isn't an issue with our Data Gateway, or permissions, etc. 

However, if I try to connect Dataverse as a data source to a Dataflow which already contains SQL Server tables, I receive the following error:

An exception occurred: 2 arguments were passed to a function which expects 1. (Session ID: d6cf1fe5-5338-4801-b421-8d63232da0a9, Region: uk)

If I do it the other way round (i.e. add SQL Server tables to a Dataflow which previously only included Dataverse tables), tables from both data sources are listed in the Queries panel on the left. However,  as soon as I try to link them, I receive the following error: 

"2 arguments were passed to a function which expects 1."

Has anyone come across this before? Or have any suggestions? 

Best regards, 

Ryan

[Syndicate_Admin]

Thank you Stephen. 

Upgrading the Gateway to the latest version (3000.122.8 - April 2022) appears to have done the trick. 

Best regards, 

Ryan

[Anonymous]

Hi @ryan_L,

Please upgrade the gateway to the latest version and try connecting again.

Also you could refer to the following similar posts:

networking - Power BI Query Error - Expression.Error: 2 arguments were passed to a function which ex...

[Expression.Error] 2 arguments were passed to a function which expects 1

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.