Forum Discussion
Installing Personal Gateway on a SQL Server
You can install the Personal Gateway on any domain connected PC so that should not be a problem at all. Note that you could install the Personal Gateway on any VM or PC you wanted, you do not have to install it on the SQL Server itself just because that is where the data lives. As long as your VM or PC can communicate with the SQL Server properly, it can retrieve the data.
You can install the Personal Gateway on any domain connected PC so that should not be a problem at all. Note that you could install the Personal Gateway on any VM or PC you wanted, you do not have to install it on the SQL Server itself just because that is where the data lives. As long as your VM or PC can communicate with the SQL Server properly, it can retrieve the data.
Hi Greg_Deckler
I have created a report and installed personal gateway on my system. I am extracting data from SQL Server, its working fine when I refresh in Power BI Desktop version but not on Power BI Online. I am getting error in my data credentials, which is the same credentials I use on SQL Server. Do I need to update it anywhere else as well. Can you elaborate what changes should I make.
"Your data source cannot be refreshed because the credentials are invalid"
PFA screenshot of my error.
| Activity ID: | 3a84f4f9-6adc-64f0-8fff-8891d069f84e |
| Request ID: | bb69b3e7-44fa-8609-3bd5-62462fc4dc72 |
| Status code: | 400 |
| Time: | Tue Jul 11 2017 16:23:50 GMT-0400 (Eastern Standard Time) |
| Version: | 13.0.1828.219 |
| Cluster URI: | https://wabi-us-north-central-redirect.analysis.windows.net |
If I use the other option, other than basic authorization i.e. WindowsWithoutImpersonation, it solves the credential error problem but still doesn't refresh.
Any help is appreciated, thank in advance.
Regards,
Sahil