Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Problems with power bi using a Sybase database

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 fa...
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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's avatar
Anonymous
Not applicable
10 years ago

ankitpatira

 

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

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    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's avatar
      Anonymous
      Not applicable
      10 years ago

      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's avatar
        Eric_Zhang
        Microsoft Employee
        10 years ago
        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.