Authentication
Power BI Desktop saves a data source credential, or sign-in identity, for each data source connection used. These credentials and settings are not stored in the PBIX file but rather on the local computer specific to the given user.
An authentication dialog specific to the data source is rendered if the user hasn't accessed the data source before or if the user has removed existing permissions to the data source in Power BI Desktop's Data source settings menu. In the following example, an Sql.Database() M query function references the AdventureWorksDW SQL Server database on the ATLAS server.
In this scenario, the user has not previously accessed this data source (or has cleared existing source permissions), and thus executing ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access