Get an error when connecting Azure SQL from power BI desktop using Service account

Winnie zhang 106 Reputation points
2023-09-01T06:22:01.1466667+00:00

I tried to connect the Azure SQL from PowerBI desktop on my local machine using the service account.

However, I got an error as below:

Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)"

And I could access the database from SSMS via my own account using below authentication mode User's image

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
43,942 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. SSingh-MSFT 16,371 Reputation points Moderator
    2023-09-01T09:50:20.5766667+00:00

    Hi Winnie zhang •,

    Welcome to Microsoft Q&A forum.

    Could you please post this query to Power BI Community Forum(https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi) in order to get assitance as currently on Q&A PowerBI questions are not supported.

    Thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.