Forum Discussion

feralvarez994's avatar
feralvarez994
Helper II
4 years ago

Conect to ODBC issue

Hi everyone! My partner has a local database that is connected to Power BI by an ODBC, he upload the file and i downloaded it from power bi service to edit and make all the dashboard that we need, and it already have all the connections to the Data base made

 

The thing is that i can use the pbi desktop file normally except when i get into Power Query, it asks me for credentials, i put them and then this alert shows up

 

in English: DataSource.Error: ODBC: ERROR [IM002] [Microsoft][Controllers Administrator ODBC] Cant find the name of the origin and theres not specified any predetermined controller (or similar traduction)
Detalles:
DataSourceKind=Odbc
DataSourcePath=dsn=SJ
OdbcErrors=[Table]

 

How can i connect to the local DB that they have and work with Power Query normally?

Need Help

2 Replies

  • KNP's avatar
    KNP
    Super User
    4 years ago

    You said you downloaded the file.

    Where is the database in relation to you? Still local, on the same network?

    Do you have the ODBC named SJ on your machine?

    There's not really enough information here to figure out your issue.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi feralvarez994 ,

     

    You need the corresponding data source credentials to access the data source.

    Try to click Edit credentials to configure the correct credentials to view the data source.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.