Forum Discussion

arne_christmann's avatar
arne_christmann
Regular Visitor
5 years ago

Power BI SQL Server on-premises data Gateway connection won't work

Hi Guys,   I am not sure if I am understanding the capabilities of Power BI and SQL server correctly. I do want to achieve the following scenario: Create Power BI Dashboards from SQL Server throug...
Need Help
arne_christmann's avatar
arne_christmann
Regular Visitor
5 years ago

Hi amitchandak ,

 

Thank you very much for your reply. At the moment I did not publish a file. I just try to connect to the SQL Server via Power BI Desktop from my local machine. I though, I could use the on-permises data gateway to do so. According to Power BI, this gateway is up and running. I can also access Tables via Power Apps, so I assume the connection between o365/on-premises SQL Server is valid:

 

 

Unfortunately, I am not able to connect to the SQL Server from my local PC via Power BI Desktop.

 

My question is: Is Power BI Desktop (or Power BI Service) capable of connecting to remote SQL Server via this on-premises gateway. And if so, how can I achieve this connection..

 

Thanks in advance,

Arne

  

arne_christmann's avatar
arne_christmann
Regular Visitor
5 years ago

I am still not able to establish a direct connection through Power BI Desktop and the SQL Server via the on-premises Gateway. However, creating a Dataflow with this Gateway through Power BI Service works. I can use it then in Power BI Desktop to publish a report. At the same time, a data-source is created, so I can work with that in Power BI Service. 

 

This feels a bit "glitchy" to me.