Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
GokulKannan42
Frequent Visitor

Sybase Database Connector

Hi,

           Steps I have done

  1. I created a custom connector in Power query.
  2. Writen code as,    let
                                     Source = Sybase.Database("localhost:1111", "DataBaseName")
                                 in
                                     Source;
  3. Copied the .mez file to Power BI Desktop --> Custom Connectors folder
  4. Open Power BI Desktop App and selected GetData Option
  5. In the connector list I am able to see my Connector.
  6. Once choosen my Connector it is popupping error message like, Unabel to Connect Credientials Required.
  7. I am  new to Power Query, Power bi Please tell me that how to add authentication and pass the crediantials to Sybase Database.
 
 

Error.jpg

2 REPLIES 2
GokulKannan42
Frequent Visitor

Hi,

 Thanks for your reply. Now I can be able to connect with my sybase database through ODBC.Datasource() function instead of Sybase.Database() and also I have give Authorization[usernamePassword()] so it is asking db user name and password(working fine). I have created a connector and it is working fine with Power BI Desktop. I have published my Power BI application to cloud, now I am getting an error message as "Failed to update the datasource credientials" while I am  trying to update my database credientials in "Data Source Credientials" option. I have searched alot, I got some suggestions like Disabling MFA authentication, install new gate way like that. I have tried the solutions which is suggested. Still I am  getting the same error message.

 

photo_2020-12-04_12-24-14.jpg

 

 

V-pazhen-msft
Community Support
Community Support

@GokulKannan42 

Can't you edit and enter the credential of Sybase Database to continue?

 

Regards
Paul

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors