Problems with power bi using a Sybase database

[Anonymous]

Hello, I am developing a BI your DW is in a Sybase database, I have encountered many difficulties regarding the communication of power bi with sybase, the automatic load often fails and worse when failure occurs the scheduling of automatic loading is disabled and no log of it is presented, opened already called to the Microsoft support however no one could help me, I have other BI's with a SQL database and never had any problem.

Someone is going through the same problem as me or have any tips of what to do?

[ankitpatira]

@Anonymous I guess you are using in-built sybase connector. I think working with MS support would be your best option as if there is any bug only they can get it fixed. You can also post it to the ideas section as bug and based on number of votes it receive you can get it prioritised. I would also suggest meanwhile you use odbc drive for sybase and connect that way and test out if that results in any issues.

[Anonymous]

@ankitpatira

I make the connection via ODBC only because my room is on primises

[Eric_Zhang]

@Anonymous

Are you talking about the scheduled refresh in Power BI Service? If yes, what does the refresh history say? Do you encounter the same error when the ODBC source is pointing to a SQL Server?

[Anonymous]

@Eric_Zhang

the log that is entered is not readable, are just codes, the same mistake does not happen when I connect to an sql

[Eric_Zhang]

---

@Anonymous wrote:

@Eric_Zhang

the log that is entered is not readable, are just codes, the same mistake does not happen when I connect to an sql

---

@Anonymous

Do you mean the problem doesn't occur when using an ODBC source connecting to SQL Server? As you've said that you are using an ODBC source connecting to Sybase. Just put the two databases into the same scenario to eliminate the possibility from db side.

[Anonymous]

thank you but it is not simple, are different environments, different customers and different projects can not migrate sybase data to sql