Power BI Store Data

Hi. Let's see. If you want to have a deep understanding about the security behind storage and platform, you can read this doc: https://learn.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security

If you want to work with reporting on premise, the Power Bi solution for that is Power Bi Report Server (integrated with SQL Server enterprise). You can check it out here: https://www.microsoft.com/en-us/power-platform/products/power-bi/report-server

The premium license can't be purchased anymore. If you want to work with the cloud you need Fabric Capacity or PowerBi Pro licenses.

You can build an on premise data warehouse and use PowerBi at cloud with a Gateway or PowerBi Report Server

I hope that helps

• Where is data stored in Power BI Service?

  • When you share a report in Power BI Service (Cloud), the data is stored in Azure regions based on your tenant location.
  • If your dataset uses DirectQuery or Live Connection, the data remains in the source and is not stored in Power BI.

• Is the data encrypted in Power BI Service?

  • Yes, data is encrypted at rest and in transit using Azure-managed encryption (AES-256). You can also use Customer Managed Keys (CMK) for additional security.

• How to trust Power BI Service security?

  • Power BI follows Microsoft’s security and compliance standards, including ISO 27001, GDPR, SOC, HIPAA, etc.
  • You can monitor and control access using Microsoft Purview, Sensitivity Labels, and Row-Level Security (RLS).

• Which Power BI service suits on-premises deployment?

  • Power BI Report Server (PBIRS) is the best option for on-premises deployment.
  • Power BI Premium Per Capacity (P SKU) includes PBIRS and allows on-premises publishing.

• Is there a cheaper alternative to Power BI Premium Per Capacity for on-premises?

  • Yes, Power BI Report Server is available with SQL Server Enterprise with Software Assurance, which may be more cost-effective.

• Can Power BI Premium Per User (PPU) be used for on-premises deployment?

  • No, PPU does not include Power BI Report Server. Only Premium Per Capacity (P SKU) or SQL Server Enterprise supports on-premises deployment.

• Your situation: On-Prem Data Warehouse & On-Prem Power BI

  • Recommended Option: Use Power BI Report Server (via SQL Server Enterprise or Premium Per Capacity).
  • This ensures all data stays on-premises while allowing Power BI report publishing.