Forum Discussion

JBeyers's avatar
JBeyers
Advocate IV
9 years ago

Error when loading DirectQuery PBIX file: Datasource has no credentials, unable to Patch the gateway

Hi, 

 

I wanted to test out PowerBI embedded so I downloaded the sample app that is able to publish a pbix file and to embed it.

So I created the easiest PowerBI file one is able to make with Azure SQL, using the DirectQuery option, as underlying data source.

 

I succesfully imported the PowerBI file in my workspace collection

 

I changed the connection string of my PowerBI file succesfully

 

After that the code to patch the gateway with the username and password credentials fails

 

Then when I tried to view the embedded report I got this error. 

I believe the connectionstring is in the correct format because it was updated succesfully. I also already tried to point it to another SQL database and then the error shows the other SQL database in the error message.

 

1) I thought this could be because the Gateway does not get the credentials that I gave it is that correct?

2) And how can I fix this?

 

Thanks in advance!

 

Need Help

7 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    JBeyers

     

    At the moment I post, it shall work. It seems a period outage and right now it works. I get the positive reponse from the ones who had the same error in this link.

    • JBeyers's avatar
      JBeyers
      Advocate IV
      9 years ago

      Hi Eric_Zhang, 

       

      Thanks for your response! I tried this but instead of a NotFound exception I received a BadRequest.

      However I'm able to update my credentials with:

       

      await client.Datasets.SetAllConnectionsAsync(workspaceCollectionName, workspaceId, datasetId, connectionParameters);

       

      Here is a screenshot of the output

      • JBeyers's avatar
        JBeyers
        Advocate IV
        9 years ago

        Finally found the issue! When I used PowerBI-CLI the problem became a bit clearer. Apparently I needed to "Allow access to Azure services" in the relevant SQL database. After that I could finally Patch the Gateway and now I can see data in my report.

         

        We definitely need more/the same feedback in the PowerBI API SDK!

         

        This was my error (the IP Address is an Azure IP Address):

         

        [ powerbi ] {"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Cannot open server 'engiep-dev-weeu-sql' requested by the login. Client with IP address 'xx.xx.xx.213' is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2146232060"}},{"code":"DM_ErrorDetailNameCode_UnderlyingNativeErrorCode","detail":{"type":1,"value":"40615"}}]}}}