Can a Power BI Dataset be setup to refresh without an actual user? It would be great from an automation perspective and to avoid being tied to someone specific. Adam digs in.
Service Principal Video:
https://www.youtube.com/watch?v=1SO19uik1rw
Add-DataGatewayClusterUser (DataGateway CMDLET – Add to Admin List)
https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusteruser?view=datagateway-ps
Add-DataGatewayClusterDatasourceUser (DataGateway CMDLET – Add to Datasource User list)
https://docs.microsoft.com/powershell/module/datagateway/add-datagatewayclusterdatasourceuser?view=datagateway-ps
Invoke-PowerBIRestMethod (Power BI CMDLET)
https://docs.microsoft.com/powershell/module/microsoftpowerbimgmt.profile/invoke-powerbirestmethod?view=powerbi-ps
Datasets – Take Over In Group (Power BI CMDLET / REST API)
https://docs.microsoft.com/rest/api/power-bi/datasets/take-over-in-group
Datasets – Bind To Gateway In Group (Power BI CMDLET / REST API)
https://docs.microsoft.com/rest/api/power-bi/datasets/bind-to-gateway-in-group