Data source settings

The Data source settings menu provides access to the authentication and privacy levels configured for each data source within the current file and the saved permissions available to all of the user's Power BI Desktop files.

This menu can be accessed under the Edit Queries drop-down on the Home tab of Power BI Desktop's report view or from the Home tab of the Query Editor, as shown in the following screenshot:

Data source settings menu in Power BI Desktop

In this example, the user chose to save the Windows authentication to the ATLAS server rather than the specific database (AdventureWorksDW) on the server. The Edit Permissions... command button provides the ability to revise the authentication, such as from Windows to database or to enter a new username and password.

The Edit... command of the Edit Permissions menu, highlighted in the following image, prompts the same SQL Server credential menu that was used when originally configuring the method of authentication to the data source:

Edit credentials accessed via Edit Permissions

Many organizations set policies requiring users to regularly revise their usernames or passwords for certain data sources. Once these credentials have been updated, the user should utilize the Edit Permissions menu to ensure that the updated credentials will be used for M queries against this data source. Depending on the security policy of the data source, repeated failures to authenticate due to the outdated credentials saved in Power BI Desktop can cause the user's account to be temporarily locked out of the data source.

Table of Contents for Data source settings

Create new playlist

Sign In

Sign Up

Table of Contents for
Data source settings