The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello all:
I have a Standard Gateway installed. There is a Dataset configured that uses and ODBC connector. I have a Power BI Model PBIX file deployed that uses that Gateway and Dataset. Refresh works fine.
I now want to create a Dataflow that uses that same Gateway and Dataset ODBC connection. But the only option I have is to create a new connection. Why can I not reuse a Dataset already configured?
Proud to be a Super User! | |
I see it now. The trick/bug is that the Connection String is CASE Sensitive! WTF?
This is what I have in place now for Data Source under the Gateway:
If I create a Dataflow for ODBC, and type in a Connection String of "dsn=CData QuickBooks Sys" then I get this, and it associates with an existing Dataset:
But my standard is to capitalize the "DSN", so I normally go for something like "DSN=CDataQuickBooks Sys" and I am offered this:
Note that the Connection name is spelled EXACTLY the same as one that already exists.
The result is this:
Please note how Power BI has NOT figured out that "DSN=..." is the same as "dsn=..." so it created a new one with "(2)" suffix, and ALSO that is then decided to LOWERCASE the "DSN" to make it "dsn".
Not for nothing, but if Connection Strings are CASE SENSITIVE, THEN POWER BI SHOULD NOT BE CHANGING THE CASE OF THE SPELLING!!!
You can't have it both ways. If the Connection String is CASE SENSITIVE, then don't change the case on me, the user. If it is NOT CASE SENSITIVE, then please accept "DSN=..." as a match to "dsn=..."
I still consider this a BUG, but not under the same title!
This user experience is horrible! When setting up a Dataflow, I should be allowed to PICK any existing ODBC Data Source BY NAME. I should NOT be required to spell out the Connection String WITH CASE MATCHING in order for it to figure out it is the same object! And oh, by the way, Power BI RENAMED your connection string behind your back from when you first typed it in and didn't tell you, so if you try to spell out that same connection string exactly as you did before during a subsequent setup, you are going to get a duplicate!
Proud to be a Super User! | |
Hi @ToddChitt ,
If you are just looking at the initial screen, it does appear that you need a new connection. However, if you have an existing connection, when you put the data source connection string into the Connection Settings the connection and connection name will find the existing gateway connection. (Assuming that you have the correct gateway selected lower in the selections options.)
Proud to be a Datanaut!
Private message me for consulting or training needs.
Sorry, @collinq but when I just type in the name (I actually went to the Gateways page, copied the Name to the clipboard and pasted it in the setting) I get a second Dataset with (2) appended to the name.
Before and after:
Proud to be a Super User! | |
HI @ToddChitt ,
I didn't see any screenshots, could you please repost?
Proud to be a Datanaut!
Private message me for consulting or training needs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
52 | |
22 | |
11 | |
11 | |
9 |
User | Count |
---|---|
112 | |
32 | |
30 | |
20 | |
19 |