Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Desktop Connection Issue with Lakehouse: Integrated Security Not Supported Error

I've encountered an issue while trying to connect Power BI Desktop to our lakehouse data source. The error message that appears is as follows:

"Unable to connect
We encountered an error while trying to connect.
Details: 'Microsoft SQL: Integrated Security not supported.'"
please give the solution 

Need Help
Tips and Tricks
  • bcdobbs's avatar
    bcdobbs
    2 years ago

    Click the down arrow on transform data and click data source settings.


    Clear the permissions for the lakehosue.

     

    Come back out and click refresh. It will prompt for credentials... SQL auth isn't supported so you need to use Microsoft account or a service principal.

1 Reply

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    2 years ago

    Click the down arrow on transform data and click data source settings.


    Clear the permissions for the lakehosue.

     

    Come back out and click refresh. It will prompt for credentials... SQL auth isn't supported so you need to use Microsoft account or a service principal.