Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
5 years ago

Security issue

Hey evryone!   Is it possible to connect an internal Database of an organization to PowerBi Do Publish and not upload the information to the Azure cloud?
Data Protection
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

hi netanel 

 

You could this this with DirectQuery, whilst this works it could be very slow due to the underlying database taking all the load.

 

You could also look at Power BI Report server where everything is hosted locally?

Power BI Report Server | Microsoft Power BI

 

Or you could create a SQL Server Analysis Services Tabular Database locally and then connect to this SSAS database via the Gateway?

On-premises data gateway for Azure Analysis Services | Microsoft Docs

  • netanel's avatar
    netanel
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    First of all thank you!
    Second if I have a client who has a free account, and he does Publish
    His data  also go to the cloud?