Connection establishment error from Client PC(Power BI PC) to SQL server PC. Network status ok them

[Emranit]

I'm trying to connect power BI pc to sql server database. But connection not establish. Network status ok from Power BI pc to sql server PC. Showing attached image. Anybody help me in this regard.

[Emranit]

Connection establishment error from Client PC(Power BI PC) to SQL server PC. Network status ok them. Please see the video & image.

[Emranit]

https://youtu.be/jlG3Y5ZcbGo https://youtu.be/OwguXn2_dyE 

[Emranit]

Yes it is working

[v-xiandat-msft]

Hi @Emranit ,

Thanks for @tharunkumarRTK  reply, as he says, if you can connect successfully in SSMS then the problem may be coming from within the pbix file, due to an automatic change applied in the report data source settings.

Clear all permissions for the data sources with this problem (some of which have "Windows" credentials and "Organization" privacy level). Then, set the Credentials to Windows again, and set the Current User Authentication and Privacy Level to None, with all credentials encrypted.

Below is the post will help you:

Error connecting Excel or PowerBI to SQL Server (System.EnterpriseServices) - Microsoft Q&A

Best Regards,

Xianda Tang

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

[tharunkumarRTK · Accepted solution]

@Emranit 

Are you able to connect from SQL Server Management Studio? Error message indicates its a impersonisation issue, Please check whether you have enough permissions to access the db.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Emranit]

In my DB user picture access granted. Is it sufficient to connect from power BI to sql PC.