CODEWITHSUNDEEP
powerbi
variable
variable

Reputation: 9664

What credential are used by report using direct query or live connection?

Power bi report in the import mode uses the credential configured in the gateway to access the underlying sql server database.

What credential is used when report uses:

  1. Direct query mode to sql server db
  2. Live connection to SSAS cube

Upvotes: 1

Views: 736

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89006

Live connect to AAS and Power BI Datasets uses AAD auth with the identity of the report user. There is no option to use a stored credential.

Live connect to SSAS connects through the On-Prem gateway using a stored credential of an SSAS admin and passes the end user identity using the EffectiveUserName connection string parameter. See Manage your data source - Analysis Services

For DirectQuery to SQL Server SSO is optional.

enter image description here

Upvotes: 1

Related Questions