Forum Discussion

gavin007's avatar
gavin007
Helper V
4 years ago
Solved

DIrect Query Report with error when open in Service

Hi, i encounter issue when open the direct query report in power bi service.    Data is connected to Azure SQL DB. it was working before. The same dataset with import mode is working fine.    I t...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, gavin007 

     

    For the best experience to connect to your Azure Synapse Analytics data source, use Power BI Desktop. Once you've built your model and report, you can publish it to the Power BI service. The previously available direct connector for Azure Synapse Analytics in the Power BI service is no longer available.


    This is the relevant document, hope to help you:

    https://docs.microsoft.com/power-bi/connect-data/service-azure-sql-data-warehouse-with-direct-connect 

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gavin007's avatar
gavin007
Helper V
4 years ago

I found out it has something to do with the encrepyted connection in the datasource setting in desktop. Once I turn off the encrypted connection, it works. I just don't understand why it work. 

 

I did some research and the following doc says the The direct connector for Azure SQL Database in the Power BI service is now deprecated. I am not sure what is this mean. But looks like DQ to Azure SQL DB is required to set up in desktop first. 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect#single-sign-on

 

 

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, gavin007 

 

For the best experience to connect to your Azure Synapse Analytics data source, use Power BI Desktop. Once you've built your model and report, you can publish it to the Power BI service. The previously available direct connector for Azure Synapse Analytics in the Power BI service is no longer available.


This is the relevant document, hope to help you:

https://docs.microsoft.com/power-bi/connect-data/service-azure-sql-data-warehouse-with-direct-connect 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.