Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ODBC credentials vs gateway credentials

I would like to ask what 2 questions: 1) What is the difference between the credentials you type on your gateway:     and the credentials you type when setting up the ODBC connection with t...
Need Help
Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

For your first question,

When you add a data source, the credentials is used to connect from the gateway to on-premises data sources. 

When you set up the ODBC connection with the database, the credential is uesd to connect from Power BI Desktop to ODBC.

You can refer to this post.

 

For your second question,

The credential has been set after you add a data source.

 

Best Regards,

Icey

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you Icey for the information.

     

    So when I add a datasource on the gateway, the credentials I write there can be anything I want right? After I've added these credentials, when will I need to type them again?

     

    Also, if I got it correctly, if I add a data source on Power BI Desktop, the credentials I have to write should be the same with the ones I wrote when setting up the ODBC. Is that correct?