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
amitchandak's avatar
amitchandak
Super User
5 years ago

arne_christmann , is the machine having gateway able to access the SQL server and Gateway has same user credential as the one you have used to publish the file.

 

In this video after this time, I have Shown SQL Server Gateway config - https://youtu.be/cf-YNWX8Qow?t=3423

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.