Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

ToddChitt

Connection Strings in Gateway/Datasets are CASE Sensitive and should NOT be.

Submitted by Super User on ‎10-26-2022 04:51 AM

Plese refer to this Forum post: Re: Can't Reuse Dataset/Gateway for Dataflow - Microsoft Power BI Community

 

It appears that when creating a Dataflow based on ODBC, the Connection String is CASE Sensitive. I can verify that , while creating a Dataflow, if I type something like MyODBC for the name, and "DSN=MyODBC" for my Connection String, that Power BI CONVERTS it to "dsn=MyODBC". 

If I then do that a second time and enter the EXACT SAME VALUES, I get a Dataset named "MyODBC (2)" with a Connection String of "dsn=MyODBC".

 

If Connection Strings are CASE SENSIVE and Power BI cannot match "DSN=..." with "dsn=..." then DO NOT CHANGE THE CASE WHEN YOU SAVE IT!!!!

 

EITHER:

A) Make Connection String Case INSENSITIVE (so that "DSN" = "dsn"

OR

B) STOP CHANGING THE CASE on values I type in.

Status: Needs Info
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎10-28-2022 02:41 AM

Hi @ToddChitt 

Can you provide the corresponding screenshots for clarification ?

 

Best Regards,
Community Support Team _ Ailsa Tao

ToddChitt
Super User
Super User
‎10-28-2022 07:55 AM

As stated in the first line of this issue:

Plese refer to this Forum post: Re: Can't Reuse Dataset/Gateway for Dataflow - Microsoft Power BI Community

 

Please read that post and look for my reply dated ‎10-18-2022 07:34 AM

 

There are screen shots there, with steps I took along the way. I cannot be any more clear than that.

 

Thank you.

ToddChitt
Super User
Super User
‎12-20-2022 01:57 PM

@Anonymous You flagged this as "NEEDS INFO". I have responded with a link to the original post where by I have explained everything in great detail, including screen shots. If you need info, please tell me WHAT info you lack as I thought the original post spells everything out very clearly.

Thank you.

Jason_Platt
New Member
‎05-01-2024 09:56 AM

I am also encountering this issue, it is very annoying.

Using a self-hosted gateway (latest version), with an Oracle datasource. 

In the PowerBI web portal, if you name connections in uppercase and the powerbi report that you are uploading specifies the connection name in lower case, it will *usually* fail. It doesn't always fail, and I'm not sure why.

The only workaround I've found is to name everything in lower case, from the TNS names entry, to the label, to the connection name.

Idea Statuses