Forum Discussion

RWFrederick's avatar
RWFrederick
Frequent Visitor
8 years ago
Solved

Dataset Refresh Failure via On-prem Gateway Data Source

I've created a new Data Source using "Manage Gateways."  This setup shows the "Connection Successful" message.  I've created a new report in Power BI Desktop, carefully created the Get Data connectio...
  • v-sihou-msft's avatar
    8 years ago

    RWFrederick

     

    Please "Edit credentials" in dataset setting. Then try to refresh the dataset to see if it works. 

     

     

     

    Regards,

  • RWFrederick's avatar
    8 years ago

    It's been months since my first post but I wanted to follow-up for other users that might find this thread.  The "marked solution" in my case was not a solution.  See the screenshot that shows manual edit of credentials isn't even an option for a dataset granted access to the Data Source.

     

    The root cause:

    Server name mismtach between our listener's certificate and the target priamry instance in our cluster.

     

    The solution:

    (1) Easy, short-term: create a Data Source connection directly to the primary instance using the FQDN (though defeates the purpose of our HA cluster).

    (2) Medium, long-term: update & manage the certificate on the listner.