Create service principal user PBI

PHOTO

Thu Mar 13 2025 11:59:40 GMT+0000 (Coordinated Universal Time)

Saved by @merol007

CREATE USER [sp-pbi-api] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [sp-pbi-api];

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Azure SQL DB

@merol007

Check user roles Controleer schema permissions database user Aanmaken database user/managed identity (volledige lijst) Create service principal user PBI

Browse more snippets >>