Forum Discussion

johnmelbourne's avatar
johnmelbourne
Helper V
6 years ago

Connect to off-premises external vendor SQL database

Hi, We have an external vendor providing a database solution and I want to connect to it via Power BI. Can someone direct me to some resources as I am having issues and most help refers to connectin...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi  johnmelbourne ,

 

If you did so,you should first make sure that you have access to the data source provided by the vendor,then you  should also make sure that you can connect to the related gateway for refresh.Both the 2 steps may cause issues during maintenance.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

 

johnmelbourne's avatar
johnmelbourne
Helper V
6 years ago

Thanks, I already have a configrued gateway that is connecting to the external database. I think getting them to create a pbix locally and then me uploading to the service is the way forward.

 

Thanks

 

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi johnmelbourne ,

     

    Yes,when you get the .pbix file,modify the data source credential,which should be same with the setting in gateway.See below:

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!