Forum Discussion

HannahC's avatar
HannahC
Frequent Visitor
9 years ago
Solved

Error when connecting to report that uses DirectQuery to SQL Server

Hi,   Newbie here :)   I published a report that uses DirectQuery to SQL Server. I have the personal mode gateway installed. The report looks fine on my desktop, but online I'm getting the error ...
Gateways
Reports
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

HannahC

 

Please use on-premises data gateway instead of personal mode of on-premises data gateway. For data sources other than Azure SQL Database or Azure SQL Data Warehouse that use DirectQuery, and Enterprise Gateway must be installed and the data source must be registered to establish a data connection.

 

If you are using import mode to SQL Server, you can use personal mode of on-premises data gateway.

 

Please refer to following Matrix. Reference: https://powerbi.microsoft.com/en-us/gateway/.

For how to use on-premises gateway, you can refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/.

 

Best Regards,
Herbert

  • HannahC's avatar
    HannahC
    Frequent Visitor
    9 years ago

    Hi Herbert,

     

    Thanks very much for this.

     

    I was getting errors trying to download the non-personal mode, but I can ask IT to try again.

     

    Thanks,

    Hannah