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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

ODBC Connection error

Hi

 

I have a couple of basic Dataflows up and running which, via the on-prem gateway and an ODBC connection, have been working fine for a week or so.

music43_1-1613408271452.png

Today, I have gone to edit one and I am getting an error ODBC driver error:

ODBC: ERROR [HY000] [IBM][System i Access ODBC Driver]Key value in connection string too long.

music43_2-1613408343613.png

Nothing has changed from the ODBC perspective. I also checked the same connection string in Excel and it is working as expected.

music43_0-1613408250876.png

 

It appears to be an issue with the service only.

 

Thanks

Oli

 

 

Status: New
Comments
v-chuncz-msft
Community Support

@music43 

 

You may keep an eye on the Awareness.

Power BI customers editing existing dataflows that use the on-premises gateway client may see the message, "Please specify how to connect". Any changes made will not be saved. Engineers have identified the root cause and a fix is expected to be deployed by end-of-day 02/22/2021

music43
Advocate II

Hi @v-chuncz-msft 

 

Thank you for pointing out the Awareness page. I wasn't aware of it 🙂

 

I also (just) found that under the project options - setting the On-Premise gateway fixed the issue

music43_0-1613469082027.png

Thanks