Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Scheduled Refresh using alternate Windows Credentials

In the Power Query Editor (in PBI Desktop), when you connect to a SQL Server database you can choose to use Windows authentication instead of SQL Server credentials. You can also choose to provide al...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    The problem may be that the account connected to SQL is not the same as the power bi service login account.

    If you want to log in with alternate credentials, you need to log in to power Bi as the user.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Anonymous ,

 

The problem may be that the account connected to SQL is not the same as the power bi service login account.

If you want to log in with alternate credentials, you need to log in to power Bi as the user.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the reply, V-lianl-msft. I think you answered my question, but I just want to confirm.

     

    My question was whether it is possible to log in as one user, but supply a different Windows user/pw to access SQL Server from PBI Service. This is already something I can and have done with PBI Desktop. Are you saying it's impossible in PBI Service without logging into PBI as that user? Because that is not an option for me, the user I am trying to log into SQL Server with is a system-generated account that does not have a PowerBI account.

     

    It sounds like my only other alternative is to create a custom data connector in M and use that data connector instead of the default SQL Server connector that PBI Service provides (which doesn't have the same functionality as PBI Desktop connector for some reason).