Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DO I need Visual studio and Power Query SDK to connect Power BI report to On-Premise SQL server???

I have published a report on PowerBI server, however it needs to connect to an on premise SQL server database. I read from documentation that I need to create a PowerQuery connector.  DO I need to ha...
Need Help
Tips and Tricks
KNP's avatar
KNP
Icon for Super User rankSuper User
4 years ago

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/

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.