Cant Connect SQLEXPRESS to Power BI

[a7n]

Hi All 

Having the below issues when i am trying to connect AdventureWorks2014 on SQLEXPRESS instance running on my local machine.

I have made sure the Server is running

I have logged in 

and trying to connect PowerBI as below

Any thoughts what is going on  ?

[v-yuezhe-msft · Accepted solution]

Hi @a7n,

In your scenario, you use wrong Server name when connecting to SQL Server in Power BI Desktop. Please enter “ServerName\SQLEXPRESS” or “localhost\SQLEXPRESS” in Server textbox in Power BI Desktop.

Thanks,
Lydia Zhang

[a7n]

“localhost\SQLEXPRESS”

Worked perfectly 

Thx

[perpor]

I have the same problem but with an instance of Sql server, please help

[perpor]

and when I use Sql server Management studio I use the windows connection.....

[perpor]

sorry, the Windows Authentication, maybe is this the problem ??

[perpor]

solved, worked writing the name of the server in Uppercase (?? bo..)

[perpor]

NOT SOLVED.. i HAVE ALWAYS THE ERROR:

Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I have used a file .pbix with connection to a remote db, I have only chenged to point to a local db Sql server,

apparently does not work with direct query, works only 'import'...

[perpor]

please hekp me, I need to use direct query to DB, not import the whole table...

[perpor]

and the option 'direct query' is always NOT enabled...

[perpor]

[perpor]

I have find a speedy solution creating a user on the localhost db, giving it a lot of permissions, and connecting with sql server authentication, and not with windows auth., so it works