Forum Discussion
U2 Universe database ODBC connection
Super UserI have the same problem. Still can't connect ODBC driver. I solve this for now connecting the with R script throw ODBC driver.
The problem is that R script doesn't work with Enterprise - On premise Gateway. So i don't know what i am going to do when i finished my reports.
It sucks because udl file and R can connect throw the driver, but power bi can't.
Maybe is the 32/64bits driver or something like that.
Regards, hope someone get the solution soon.
P/D Odbc.DataSource("dsn=name") doesn't work.
Helper IIHi
I can connect to my Universe data source via the ODBC connection and i can see my tables
When i select a table however i get the error
DataSource.Error: ODBC: ERROR [S1003] [Rocket U2][U2ODBC][2200285]SQL data type out of range.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=UniverseDev
OdbcErrors=Table
- ibarrau
I finally connect too. With the newest driver the error on the previous post are over.
I manage to get the data without selecting the table. I open the advanced options and write a SELECT * FROM TABLE.
Hope that help
Regards,
- Karl-D
Helper I
Agreed. With older drivers, I was able to get each table individually using Advanced and entering a query.
With the newer drivers, 7.241.02.9004 10/17/2022 U2ODBC.DLL, I was able to use PowerBI normally, browsing and selecting tables from the database.
- gemidriver
can you please explain more?
i use this query
= Odbc.DataSource("dsn=UniverseDev", [HierarchicalNavigation=true])
and i can see the tables
how do i now write query to return data from specific table?
- ibarrau
Just add the query before connecting. Open de advance option:
Write the dsn, add the query, then when you accept it should ask for credentials and the table will be returned.
Regards, hope this helps. You can add it on power query too.
When you say that you can connect now with the 'newest driver', what driver are you referring to? Universe ODBC driver? Please show me the URL where I can download the latest driver. Thank you.
