Powershell API Update datasource

Try using "Invoke-RestMethod" with complete URL
I suppose you are also adding "Content-Type" and header with "Authorization"

Hi Anonymous ,

Here the possible solutions to try 

• Did you add the SPN as an admin to the work space ?
• Try using the fiddler to get the exact error message.
• Did you Take Over the data set using the SPN ?- This requires if you need to modify the data sources in the dataset
• You can look into my article which I gave the detailed step by step to achieve this

https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244

Would you mind sharing how you manage to get the Bearer token using Service Principal and Powershell? 

I have created a SP, added it as admin to the workspace and also added the requiered delegated permissions in Azure (Power BI Service - https://analysis.windows.net/powerbi/api/)

I can use the .Net nuget client package to do work on the workspace, updating reports/datasets and so on. But I can't manage to get the authorization token when I use either powershell, Invoke-RestMethod, or Postman.

function getBearer([string]$TenantID, [string]$ClientID, [string]$ClientSecret)
{
  $TokenEndpoint = {https://login.microsoftonline.com/{0}/oauth2/token} -f $TenantID 
  #$ARMResource = "https://analysis.windows.net/powerbi/api/";
  $ARMResource = "https://api.powerbi.com/";

  $Body = @{
          'resource'= $ARMResource
          'client_id' = $ClientID
          'grant_type' = 'client_credentials'
          'client_secret' = $ClientSecret
  }

  $params = @{
      ContentType = 'application/x-www-form-urlencoded'
      Headers = @{'accept'='application/json'}
      Body = $Body
      Method = 'Post'
      URI = $TokenEndpoint
  }

  $token = Invoke-RestMethod @params

  Return "Bearer " + ($token.access_token).ToString()
}

That's how I try to acquire the  token but I keep getting "AADSTS500011: The resource principal named https://api.powerbi.com/ was not found in the tenant named ... " (It's the same with https://analysis.windows.net/powerbi/api/) however https://management.azure.com/ returns a bearer token. 

Thank you in advance !