AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Power Bi Odac Error4/22/2021
The important piece you are probably missing is the drivers, in this case the Oracle Data Access Client (ODAC) drivers.Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.
Not the answer youre looking for Browse other questions tagged oracle powerbi powerbi-datasource ora-12154 or ask your own question. For example, I can connect to oracle via ODBC without using the Oracle Client. You might be asking why Power BI uses the Oracle ODP drivers instead of the Oracle ODBC driver - Im pretty sure the answer is that its faster and supports more Oracle features, since it doesnt have to implement a bridge. Again, as far as I know, most clients use the low-level OCI library to do this. Power Bi Odac Error Code Data TypesIt doesnt support most modern Oracle data features (Unicode data types, BLOBs, CLOBs, and so on). If i set up ODBC i dont get the error at all, so although slower, its reliable. Not the answer youre looking for Browse other questions tagged oracle odbc powerbi or ask your own question. Ive been successful in connecting to this in Power BI Desktop, ive tried to replicate this process using the Power BI Service gateway. It is returning an error complaining about locating the ODBC driver, I have confirmed I referenced the driver name correctly as seen in Power BI desktop: Attempts in Power BI Gateway, windows authentication is used on power bi desktop to connect to the data source so ive used the same credentials: This error is returned: I have confirmed the DSN and driver name in ODBC Data Source Admin. Please create a System DSN to points to your data source in in ODBC administrator, then add the ODBC data source under gateway. When adding a ODBC data source under gateway, make sure you enter the same connection string as that you get in Power BI Desktop. ![]() Also add the dbq part when entering connection string under gateway. I added the data source back in using the dbq string and the dsn string, which was successful. However, in the settings of my dataset its only askingrecognising for a personal gateway. EDIT: Ive also tried removing the existing gateway from the dashboard and re-installing on-premesis gateway, creating an entirely new gateway with a different name, then added the data source back, yet the dataset still asks for a personal gateway.
0 Comments
Read More
Leave a Reply. |