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
fabbimk's avatar
fabbimk
Frequent Visitor
6 years ago

It is currently configured with SQL server as data source type, which works when the data in the report is loaded in Import Mode. There is no separate option for Amazon RDS, only for AWS Redshift. 

 

I've found an open idea here that would probably cover what we want to achieve, seems to be a topic since 2014. 

GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

It must be because it uses some other way to connect when using DirectQuery

I would think it should work if it is seen as a SQL Server source?
  • fabbimk's avatar
    fabbimk
    Frequent Visitor
    6 years ago

    That's what we thought, but that resulted in the error message from my first post.

     

    When ticking the SSO box as you mentioned earlier we get a different error by the way: "This report couldn't access the data source. Contact [my name], the author, to have it fixed"

    • 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.