Forum Discussion
Helper IIIError when try to connect to datamart to SQL server database
Helper IIII can connect to the SQL server via Microsoft SQL Server Management Studio and Power BI desktop. Why is it not working? I need to create the data mart so I have to do it via the webbrowser.
Community SupportHi, KasperJ90
I can create a datamart normally on my side to access the data source of sql server (The authentication method used by the gateway I added is ’windows‘).
If you are sure your credentials are correct, please turn off the firewall and try again.
Best Regards,
Community Support Team _ Eason
- KasperJ90
Thanks - but why do I need a gateway? I can connect via powerbi desktop and MSSMS without an gateway with "Microsoft authorization"
- v-easonf-msft
Hi, KasperJ90
This is due to safety considerations.Power BI Gateway is a software that is required to access data situated in an on-premises network. Gateway act as a gatekeeper for the on-premises data source. If anyone needs to access on-premises data from a cloud or web-based app, the request goes through the gateway. All the connection requests are attended by the gateway and access is granted based on their authentication and requirements.
Powerbi Desktop and SSMS are native applications, so there is no need to use a gateway when accessing on-premises data.
What is an on-premises data gateway?
Best Regards,
Community Support Team _ Eason