Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have Two Servers. One Sql server and one Windows server. I want to perform Scheduled Refresh On my dashboards. I have installed Personal Gateway. In Data source credentials It is asking For Basic or Windows Without Impersonation Mode.
Can anybody Please tell me when to use these two modes of authentication?
My SQL Data source is not in Local server. When I update anything in SQL Server, It is not reflecting in Dashboards if I Select "Windows Without Impersonation" mode. And If I select Basic Authentication, It is failing to connect to data source Even if i am trying to connect it with Admin Credentials.
Can anyone help me in this issue?
Solved! Go to Solution.
Reference
https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode
The gateway needs to have access to the data source. If your personal machine cannot connect to the data source, you may want to consider installing an On-premises Data Gateway on a machine that does have access to the data source.
So in your scenario, the issue could casued by your local machine do not have access to your SQL Server machine. Please install on-premisses data gateway on your SQL Server machine and use windows authentication on your data gateway.
Regards,
Charlie Liao
Hi, in power bi service I have a data source using a service account with another windows credentials and I am unable to edit credentials (using basic authentication method do not work).
In PBI desktop we do have the option to select alternate credentials for windows but how does it work on PBI service?
Thank you,
Reference
https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode
The gateway needs to have access to the data source. If your personal machine cannot connect to the data source, you may want to consider installing an On-premises Data Gateway on a machine that does have access to the data source.
So in your scenario, the issue could casued by your local machine do not have access to your SQL Server machine. Please install on-premisses data gateway on your SQL Server machine and use windows authentication on your data gateway.
Regards,
Charlie Liao
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |