Refresh cloud based SQL server import query through Power Bi service

[khandujashish]

I am extractting data from SQL server using Import query mode. SQL server is hosted on a private cloud. Post publishing (using organization O365 credentials) my report on Power BI service, I am unbale to refresh the data. 

I am getting below error

Please suggest possible solution for this problem?

Thanks

[TomMartens]

Hey,

wondering if you have installed an "on-premises gateway" (I recommend the enterprise installation)?

It's always a good idea to create a managed domain account that will be used as a service account for the gateway.

Did you create a datasource connection utilizing the on-premises data gateway inside the Power BI service?

Regards,

Tom

[khandujashish]

Hi Tom,

Thanks for the response.

Do I need to ask my organization IT team to install this gateway? Can you please provide information in detail how this gateway works? Will the same gateway works for other team members once I share the report over Power BI service using O365 credentials ? Please let me know if my understanding is correct  -

Once report is published on Power BI service, then we need to give access to Power BI cloud to the cloud where my database is hosted, that is why we need this gateway, correct? Gateway will work as a bridge between Power BI cloud and database private cloud.

Also, it would be great of you can share some information over the security. Is this gateway secure enough to give access to organization sensitive information.

Thanks,

Ashish