Forum Discussion

perpor's avatar
perpor
Helper V
8 years ago

Unable to connect Power BI to SQL server db on the same computer

I works a lot with Power Bi and Sql server, from many months, with the db on a server remote, no problems. I have created a Sql server db on my computer, where Power BI is installed, and I can conne...
Need Help
perpor's avatar
perpor
Helper V
8 years ago


I have tried in the last few minutes and everything worked,

I swear that I did nothing more than what I did before last weeks, there are also the screenshots ... bo ...

 

true that now I have a new version of Power BI, but the version of Excel is always the same...

perpor's avatar
perpor
Helper V
8 years ago

I have always the error:

 

"Microsoft SQL: 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)"

 

 

and ONLY with this db and ONLY when I write a query, if I import the whole tables everything is ok

 

PLEASE HELP HELP HELP !!!!!!!!!!!!!!!!!!!