Power BI Dataset refresh with Service Principal Account using Windows PowerShell

Power BI Dataset refresh with Service Principal Account using Windows PowerShell

Biswarup Ghosh Biswarup Ghosh

Biswarup Ghosh

Technical Architect | Data Architecture, Azure Solutions Azure Fabric | Data Bricks | ADF | Azure Synapse | Power Apps| PowerBI | MSBI | SSIS | T-SQL |Azure Certificate 8x|8K LinkedIn family

发布日期: 2024年7月27日
+ 关注

  1. You need to install PowerBI plug-in using below command Install-Module?-Name?MicrosoftPowerBIMgmt?
  2. Open app.powerbi.com and select workspace and give permission to Service Principal account.
  3. Open Windows PowerShell with administrator privilege from start menu Connect-PowerBIServiceAccount -Tenant <Tenant ID> -ServicePrincipal -Credential (Get-Credential)
  4. Login popup will come and provide your application id as username and secrete value as Password. After click on Ok button (You will get Application id from Azure App registration)
  5. Take over PowerBI semantic model using below command Invoke-PowerBIRestMethod -Url https://api.powerbi.com/v1.0/myorg/groups/groupid/datasets/datasetid/Default.TakeOver -Method POST
  6. Give access to dataset from configuration and run query for refresh the PowerBI report Invoke-PowerBIRestMethod -Url https://api.powerbi.com/v1.0/myorg/groups/groupid/datasets/ datsetid/refreshes -Method POST

要查看或添加评论，请登录

社区洞察

其他会员也浏览了