Forum Discussion
DO I need Visual studio and Power Query SDK to connect Power BI report to On-Premise SQL server???
Super UserUnless I'm misunderstanding something, you don't need to create a connector, the gateway should do everything you need.
Once you publish the report to the service you need to go to the Dataset settings and map the dataset to the SQL environment.
You're looking for the Gateway connection settings...
My UI looks slightly different from the above. (I think it is able to identify the gateway running on my laptop, But I don't see the space for entering SQL server details, and I only see a delete icon under actions).
When I click on "Apply" button, it gives me an error as below. Do you think there may be firewall issues?
Something went wrong
Failed to use the selected gateway. Please make sure the gateway is up and running and try again.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: XXXXXXX-XXXX-XXXX-XXXX-xxxxxxxxxx
Request ID: XXXXXXX-XXXX-XXXX-XXXX-xxxxxxxxxx
Correlation ID: XXXXXXX-XXXX-XXXX-XXXX-xxxxxxxxxx
Status code: 400
Time: Thu Jan 20 2022 09:02:17 GMT-0600 (Central Standard Time)
Service version: 13.0.17535.35
Client version: 2201.3.09479-train
Cluster URI: https://wabi-us-north-central-h-primary-redirect.analysis.windows.net/
-----------------------------------------------------
Additionally, when I go to "Manage Gateways", I get the below response (even though my gateway is running):
- KNP
You appear to have it installed in personal mode. That may be causing you the issue.
If you have the option to install it in standard mode, try that and see if you have better results.
https://powerbi.microsoft.com/en-us/gateway/
hello KNP
Thank you for your answers and suggestions on this issue. I am still working on this. I do not have permissions in my org to install Standard Mode, so Currently I am working with powerbi admins. They have installed "Standard Mode" gateway on a virtual server. What I notice is that when I login with my "Pro" license, I see different set of options (I am not able to see or edit the connection string), and the PowerBI admins are able to see and edit the connection string). Currently we are working to rule out firewall issues. Once that is done, I will retry and update the results here.