Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We are experiencing issues connecting to a SQL Server via Get Data and using alternative Windows credentials.
The warning says - "We couldn't authenticate with the credentials provided"
More on the environment -
Desktop Client OS: Windows 10/Windows 7
PBI Desktop: March 2018 release
PBI Server: On-prem gateway
Get Data - Import or Direct Query
Source database: SQL Server Database
User account trying to connect: Service account (AD)
Authentication option: 'Use alternate credentials'
Note that if I select 'Use my current credentials', I can connect to the SQL server. However, if I use the same account and select 'Use alternate credentials' it doesn't work.
Also note that this service account is a local admin on the SQL Server and also a Server Admin within SQL. So there are no issues accessing databases on that SQL server using the service account in question.
I've seen some similar posts on the forum but none of the solutions work for us.
Any help would be greatly appreciated.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.