Forum Discussion

fabbimk's avatar
fabbimk
Frequent Visitor
6 years ago

DirectQuery reports not loading in PowerBI service

Hello all,   Recently we installed an on-premises gateway with the aim of sharing reports that are based on data stored in SQL server. However, when using DirectQuery we get the following error mes...
Need Help
GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

What happens if you use a SQL Server Account for authentication?
fabbimk's avatar
fabbimk
Frequent Visitor
6 years ago

It does not seem to make a difference whether Windows authentication or basic SQL server account is used. For both it says in the data source settings that the connection is successful, but when opening the report I get the same error message. 

  • TheCatt's avatar
    TheCatt
    New Member
    6 years ago

    Do you have the GatewayErrors log from the Gateway?  That will give you the definitive answer as to why your connections are failing.

     

    The generic error message obscures a lot of other errors.  

     

    For instance, if you have upgrade your AWS RDS certificate, but it's not installed on the client (gateway) machine, you will get this error, despite the data source settings test working.

     

    In the log, you'll see: [1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: SqlException:<pi>System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) ---> System.ComponentModel.Win32Exception (0x80004005): The certificate chain was issued by an authority that is not trusted