Forum Discussion
How to fetch SQL Server data from on-premises data gateway from another computer??
- 3 years ago
Hi v-xiaotang ,
Thank you for your time! I cannot do that, due to the fact that server B is in a completely different network than server A. However Server B has access to SQL Server (Server B and SQL Server are within the same network).
That is why I installed on-premises data gateway on Server B, so that SQL Server data can be queried from Power BI
My problem was that I cannot access that data from Power BI desktop (unless I install and use power bi desktop on server B, which is not feasible). I want to access that data from my work laptop
Finally what I did is create a Power BI Dataflow, using the mentioned SQL Server data source. That allows me to access to SQL Server data from anywhere using Power BI desktop (selecting Power BI Dataflow as data source)
Hi v-xiaotang ,
Thank you for your time! I cannot do that, due to the fact that server B is in a completely different network than server A. However Server B has access to SQL Server (Server B and SQL Server are within the same network).
That is why I installed on-premises data gateway on Server B, so that SQL Server data can be queried from Power BI
My problem was that I cannot access that data from Power BI desktop (unless I install and use power bi desktop on server B, which is not feasible). I want to access that data from my work laptop
Finally what I did is create a Power BI Dataflow, using the mentioned SQL Server data source. That allows me to access to SQL Server data from anywhere using Power BI desktop (selecting Power BI Dataflow as data source)