Forum Discussion
get data from Azure SMSS
I know and already done but couldn't get my data.
The issue is that the accepted sign up to Power BI should be with work email
while I worked on Azure with my gmail sign in.
So get data return error of access
The error details
Details: "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
atefaly01 wrote:
I know and already done but couldn't get my data.
The issue is that the accepted sign up to Power BI should be with work email
while I worked on Azure with my gmail sign in.
So get data return error of access
The error details
Details: "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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I'm confused how you connect to Azure SQL database. Can you check this page? It shows how to connect to Azure SQL DB from SSMS. You connect to Azure SQL DB with the same user/password as in that demo.
Hi Eric ,
I already know and worked for a whole month on the SSMS on my SQL server I configured
and the copy of sample database .
Yes .. the problem is the authentication . Power BI requires work email while connection to my SQL done with my gmail user
please check my posts above about the error of importing SQL data