topic Re: Unable to link Dataverse and SQL Server tables within Dataflows in Power Query

Unable to link Dataverse and SQL Server tables within Dataflows

Syndicate_Admin — Fri, 20 May 2022 08:48:39 GMT

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

Re: Unable to link Dataverse and SQL Server tables within Dataflows

Anonymous — Mon, 23 May 2022 08:53:39 GMT

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 expects 3 - Stack Overflow

[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.

Re: Unable to link Dataverse and SQL Server tables within Dataflows

Syndicate_Admin — Mon, 23 May 2022 09:50:47 GMT

Thank you Stephen.

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

Best regards,

Ryan