Forum Discussion

davidestg's avatar
davidestg
Helper I
8 years ago

I can't refresh data when I have 2 connections SQL and HTTP without credentials

I have a report with 2 connections: 

  1. SQL through Gateway runs ok
  2. HTTP with embeeded credentials in the URL

When I try automatic refresh, appears an error that need credentials for one origin of data. 

 

Need Help

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi davidestg

    Have you added two data source to the gateway and configured the Data source credentials in the Dataset Settings page ?

    Can you refresh them successfully in the desktop?

    Please check if the credentials are both correct.

    For SQL, you should make sure the server name and database name same as those used in Desktop and connect to SQL server via Microsoft SQL Server Management Studio with the credential used to connect the gateway.

    Which web source do you use, is it a Web API data source? How about changing the authentication type?

     

     

    Best Regards

    Maggie

    • davidestg's avatar
      davidestg
      Helper I
      8 years ago

      Hi v-juanli-msft

       

      The SQL connection is not the problem, because in other power bi I don't have problems and are correctly configurated in Data Gateway. 

       

      The issue is about HTTP connection (from the desktop I don't have problems), but I can't configure the connection in the Data Gateway because the credentials is a paremater of the public url: www.myserver.com/issues.json?key=MY_KEY_CREDENTIALS and isn't a connection with classic user/password. 

       

      I'd tried to select anonimous credentials (to use the parameter in the link web page) or specific parameters and any both solutions runs. 

       

      BR

      David