Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
We are trying to connect power BI to Sybase and its not working.
Approach 1: Tried to use Sybase connector, but getting the below error . An Error happened while reading data from the provider.The type initializer for 'iAnywhere.Data.SQLAnywhere.SAConnection' threw an exception. Its straight forward. Provided the server, database name, user name/ pwd. Is there any specific syntax to enter the server name ( lik including port number..something like that? )
Approach 2: Trying to use ODBC connector to connect to Sybase, But in that, there is no option to select the DSN. It provides only dBase files, Excel files,MS Access Database options.
Any help is highly appreciated.
Thanks
Raj
Hi,
Is your problem solved?
I could not connect through Sybase Anywhere and got a different error.
But if your database is running on another computer you must download Sybase IQ or ASE to your computer.
After that you should define the ODBC connection and test the connection.
Have a good day
@Anonymous
The approach 2 indicates the incompatibility between 64 bit Pbi desktop VS 32 bit Sysbase driver or on the contrary. In any case, please install 64 bit driver, otherwise the gateway won't work for "schedule refresh".
Hi all
We are trying to connect power BI to Sybase and its not working.
Approach 1: Tried to use Sybase connector, but getting the below error . An Error happened while reading data from the provider.The type initializer for 'iAnywhere.Data.SQLAnywhere.SAConnection' threw an exception. Its straight forward. Provided the server, database name, user name/ pwd. Is there any specific syntax to enter the server name ( lik including port number..something like that? )
Approach 2: Trying to use ODBC connector to connect to Sybase, But in that, there is no option to select the DSN. It provides only dBase files, Excel files,MS Access Database options.
Any help is highly appreciated.
Thanks
Raj
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |