Login Types

Overview

The Login Type controls how users can connect to the model from their OData client (e.g. Excel, Power BI, Power Query).

OdataLink currently provides two method:

Basic: which requires the OdataLink user name and password.
Anonymous: which does not require additional credentials.

Note that not all OData client support all approaches.

Basic

When using the Basic Login Type, your OData client will require the OdataLink user name and password to access your data.

This is in addition to other security measures of OdataLink (such as the built-in firewall).

Once set, you will need to ensure that everyone that needs access to the data is invited to OdataLink and they have been allowed to use the model.

For more information about users, see the Managing users guide.

This method is recommended for those that:

Have multiple users and want the ability to revoke access.
Have multiple models aimed at different users.
Want the most secure way to access their data.

Notes for Excel users

Excel stores the credentials separately from the Excel Workbook. As such, users will have to enter their own user name and password in order to refresh the data.

Notes for Power BI desktop users

Power BI stores the credentials separately from the Power BI file. As such, users will have to enter their own user name and password in order to refresh the data.

Notes for Power BI cloud users

For Power BI (cloud) users, the credentials will not be included and published with the Power BI reports and dashboards. They will need to be re-entered within the Data Sets or Data Flows settings page.

Once entered, all Power BI (cloud) users that have access to the reports will be able to refresh it.

Anonymous

When using the Anonymous Login Type, your OData clients will be able to access your data without needing additional credentials.

Other security measures of OdataLink will still be enforced (such as the built-in firewall).