Issue with refreshing dataflow - the key isn't supportet

[wabanek]

Hi, 

Since yesterday i started to receive below error when refreshing data on dataflow connected to MSSQL on premisses via gateway. Does anyone have such a problem too??

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=ArgumentException
InnerMessage=<pi>The keyword isn't supported: configurationproperties.
Parameter name: keyword</pi>
InnerToString=<pi>System.ArgumentException: The keyword isn't supported: configurationproperties.
Parameter name: keyword

[Antonio03]

I already did it and I still have the same problem, I see that several continue to have the same problem even when they updated their gateway.

[Anonymous]

Antonio03, have you already check that the configuration of the dataset connection gateway  is OK?

[rargyle]

Microsoft Support ticket is now closed as the resolution was update the gateway to the latest version. 

New versions are released monthly, and Microsoft support the past 6 versions.

If your version is older than 6 months then expect problems.

[wd6ae]

We updated the gateway and that resolved this issue.

[Antonio03]

Have you received any response to this.?

[Anonymous]

In my case, all the dataflows conenctions were reconfigured to other gateway connection. Assigning one by one the right connection solved the issue.

[wabanek · Accepted solution]

Updating Gateway to newest version solved the problem. 

[Anonymous]

Hi everyone...

We are getting the same error since this morning. I'm going to request a GW update to see whats happen.

Is this something related to the GW software update? It's really annoying.

[bimotor]

Hi just to update everyone - I updated the on-premises gateway to 3000.110.5 and this has resolved my issue.

[Anonymous]

Hi. PBI dataflows are refreshing but when I edit the data flows Its throwing the same error as mentioned.

Please let me know how do I update on-premises gateway? Please share any link or documention the upgrade.

[rargyle]

To update the Gateway to the latest version, please follow the instructions here...

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-update

[bimotor]

Same issue here.

So frustrating, as I've just launched a report using dataflows. Now getting complaints from everyone.

Mine failed on 15/2/22, worked on a manual refresh. Now, even manual refreshes do not work. Editing in the query editor yields no useful information. Just the same generic message.

"The keyword isn't supported: configurationproperties.

Parameter name: keyword"

Cannot even see the server I'm trying to connect to.

[rargyle]

I have same issue too, with Dataflows using Oracle and SQL Server data sources through On-premises Gateway.

Datasets connected to same tables via gateway are ok.

I've submitted a Support Ticket to Microsoft.

[wd6ae]

Yes, we have exactly the same error this morning when our dataflows were set to do their daily refresh.  I have gone into the dataflow and get the same error when trying to edit a table.