Forum Discussion
Solved
Creating semantic model sql connection error
Hi all, I am new here and new to Power BI and I'm having some errors. Hopefully someone will be able to help. I have uplaoded Power BI dashboard and created gateway on-premises. Now, I want the dash...
Hi johnbasha33,
Just wanted to add that this has been resolved. The server needed to be added to the SQLTrustedServers in the config file.
Regards
Renata
Hi johnbasha33,
I had to park this task for some time but I came back to it. Thank you for your response. I've checked everything based on your suggestions and all is correct and enabled. But I stil can't connect to SQL server. This is the error message I have:
Unable to create connection for the following reason: Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller for the authentication request.
Do you have any more suggestions, please?
Hi johnbasha33,
Just wanted to add that this has been resolved. The server needed to be added to the SQLTrustedServers in the config file.
Regards
Renata