Forum Discussion

hellodfkh's avatar
hellodfkh
Frequent Visitor
2 years ago

PowerBI Gateway : SQL + VPN Source

Hi forum,    I am developing a dashboard which will connect to a SQL Server which is further secured by access only through a Virtual Machine and a VPN. My end goal is to embed the report in a flas...
Data Protection
Need Help
TomMartens's avatar
TomMartens
Super User
2 years ago

Hey hellodfkh ,

 

next to what GilbertQ  already mentioned, keep in mind that you have to import the data to your Power BI semantic model, as direct query connection types are not supported by the "Publish to web" feature: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web

 

Not sure, but it sounds a little bit awkward that you want to share data from server "secured" by vpn machine with the public internet.

 

Regards,

Tom

hellodfkh's avatar
hellodfkh
Frequent Visitor
2 years ago

Thank you so much TomMartens GilbertQ for the reply. In this case then, how do I make the dashboard live to the public? The scenario is that though the data is in secure environments, the analysis on top of the data has to be made public.

  • TomMartens's avatar
    TomMartens
    Super User
    2 years ago

    Hey hellodfkh , 

     

    if the requirement is to make the data public, there is no other way than "Publish to web."

    This means you have to import the data from the SQL Server to your semantic model.

     

    Unfortunately, I'm not able to help regarding the VPN.

     

    Regards,

    Tom