Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem to Modify Dataset Credential

Hello, i hope you´re doing well.   I´m having this issue every time i try to modify credential of the Dataset.   Invoke-PowerBIRestMethod : One or more errors occurred. At C:\Users\ZN661HL\sourc...
Need Help
  • Jayendran's avatar
    Jayendran
    6 years ago

    Hi Anonymous ,

     

    I'm not sure you are using SPN or master account. In either of the case please make sure to give access to the workspace as admin.

     

    Then you make sure to take over the dataset before udpating the credentials ? 

     

    As the error saying it's not found. May be you are missing either of the above two.

     

    For AzureSQL i don't think you need on-premises Data gateway. But the bounddefault gateway should always need ,which is quite different from the typical on-premises data gateway.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, here the error i´m getting :

 

HTTP/1.1 404 Not Found
Cache-Control: no-store, must-revalidate, no-cache
Pragma: no-cache
Transfer-Encoding: chunked
Content-Type: application/json; odata.metadata=minimal
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Frame-Options: deny
X-Content-Type-Options: nosniff
RequestId: 52113063-e1ce-45ba-979d-1760cd5e88a4
OData-Version: 4.0
Access-Control-Expose-Headers: RequestId
request-redirected: true
home-cluster-uri: https://wabi-europe-north-b-redirect.analysis.windows.net/
Date: Tue, 16 Jun 2020 14:59:18 GMT

EB
{
"error":{
"code":"","message":"No HTTP resource was found that matches the request URI 'http://wabi-europe-north-b-redirect.analysis.windows.net/v1.0/myorg/gateways/7f7807d7-c24a-42e4-b578-f3fb418980bb/datasources/'."
}
}
0

 

I´m using this code to retrieve the gateway:

 

i took this code from your ci cd pipeline  Jayendran

 

 

$BounGateway = Invoke-PowerBIRestMethod -Url "groups/$($workspace.id)/datasets/$($datasetid)/datasources" -Method GET | ConvertFrom-Json

 

i already tried using the power bi UI to update credential and i was able to do it, but i realize that gateway.id and datasource id were diferents. 

 

This is what i get from power bi UI.

 

This is using Invoke-PowerBIRestMethod

gatewayid=7f7807d7-c24a-42e4-b578-f3fb418980bb

datasourceid=846f9253-72f4-4f85-abcd-04ee75e5dce5

 

completly diferents.

 

 

 

Jayendran's avatar
Jayendran
Solution Sage
6 years ago

Hi Anonymous ,

 

Both gateways are totally different you should not compare it. The boundgateway is used by microsoft behind the screen in other hand the gateway url which you got is the one which you installed it.

 

What is your data source ? Is that a cloud or on-premises (using any on-premiese datagateway) ?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Jayendran ,

     

    I´m using Azure Sql Server, i don´t remember having installed a gateway.

     

    might it have installed because i'm using a vpn to connect to azure sql server?

     

     

    • Jayendran's avatar
      Jayendran
      Solution Sage
      6 years ago

      Hi Anonymous ,

       

      I'm not sure you are using SPN or master account. In either of the case please make sure to give access to the workspace as admin.

       

      Then you make sure to take over the dataset before udpating the credentials ? 

       

      As the error saying it's not found. May be you are missing either of the above two.

       

      For AzureSQL i don't think you need on-premises Data gateway. But the bounddefault gateway should always need ,which is quite different from the typical on-premises data gateway.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Thank you Jayendran , you were right i was missing take over dataset before update credential.

         

        one more time thank you.