Forum Discussion

paritoshmishra's avatar
paritoshmishra
Icon for Helper I rankHelper I
5 years ago
Solved

Devops Automation of Embedded Power BI

Scenario We have 10  Azure  SQL Database  Server and each server has almost 10 databases. Each database associates with each client. I have embedded Power BI with our enterprise sites. I have imp...
Need Help
  • paritoshmishra's avatar
    paritoshmishra
    5 years ago

    This is solved. Place of  Powershell  variable declaration in a script   have  an issue

     

    Thanks  

paritoshmishra's avatar
paritoshmishra
Icon for Helper I rankHelper I
5 years ago

I have run Power BI API to change database  by calling 
"$datasourePatchUrl = "https://api.powerbi.com/v1.0/myorg/groups/$targetworkspaceId/datasets/$importeddatasetId/Default.UpdateDatasources"  .I have used admin user credential hardcoded to acquire token. 
Its works perfectly on my local computer 

By when  I run the same script on Vsts pipeline on powershell task , its run all PowerBI rest api such as aaquire token , get workspaces , get datasets ect , but its fails while updating db change "Default.UpdateDatasources"  api .Its throw error " 

The remote server returned an error: (404) Not Found." 

I didn't understand how 404 status throw even  same script run perfectly on local

Please help me out 

TIA



v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi paritoshmishra ,

 

In other words, you can execute this script on the local PowerShell, but you can’t execute this script on Azure Pipelines?

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • paritoshmishra's avatar
    paritoshmishra
    Icon for Helper I rankHelper I
    5 years ago

    This is solved. Place of  Powershell  variable declaration in a script   have  an issue

     

    Thanks