topic Re: Report Server Implementation in Report Server

Report Server Implementation

Anonymous — Mon, 21 Apr 2025 02:52:35 GMT

**Looking for Suggestions from the Power BI Community**

We’re currently working with a client who has a **strictly offline environment**—no internet access at all—and they are looking to implement **Power BI for reporting and dashboarding**.

Here’s what we have:
- A **64-core SQL Server** (no Software Assurance currently, and the previous SA has expired).
- The client needs a **completely offline Power BI setup**—no Power BI Service, no cloud access.
- We understand Power BI Premium license has undergone changes recently, and it seems some capabilities have been shifted or removed.

We’re exploring options for on-premises deployment using **Power BI Report Server**, but we’re running into licensing limitations due to the lack of Software Assurance.

**Our questions:**
1. What are the current options to legally obtain and use Power BI Report Server without SA?

2. Any alternatives to Power BI for fully offline environments you’ve successfully implemented?

3. How are teams handling the recent **Power BI Premium changes** in similar secure or air-gapped setups?

4. Any architectural or deployment best practices for fully offline Power BI environments?

Any input, thoughts, or shared experiences would be hugely appreciated!

#PowerBI #DataAnalytics #OnPremises #PowerBIReportServer #OfflineBI #SQLServer #EnterpriseReporting

Re: Report Server Implementation

v-venuppu — Mon, 21 Apr 2025 10:32:23 GMT

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community.

Here are some insights that answer your questions:

1. What are the current options to legally obtain and use Power BI Report Server without SA?Power BI Report Server (PBIRS) is still available only through:

Power BI Premium Per Capacity
SQL Server Enterprise Edition with Software Assurance (SA)

Without SA, you cannot legally deploy PBIRS unless you subscribe to Power BI Premium Per Capacity, and even then, you'll likely hit connectivity issues in a fully offline setup.

2. Any alternatives to Power BI for fully offline environments you’ve successfully implemented?

Here are some on-premises BI tools that work in offline:

a.Tableau Server (on-prem)

Fully on-prem deployment is possible.

Requires activation (can be handled via offline methods).

Good dashboarding capabilities.

Costly, but flexible in secure environments.

b.Qlik Sense Enterprise on Windows
Strong support for offline and air-gapped environments.

Easy to deploy and scale on Windows servers.

Flexible licensing.

c.TIBCO Spotfire
Commonly used in high-security and scientific environments.

Offline licensing and deployment supported.

Rich in analytics capabilities.

d.Metabase (Self-Hosted)
Open-source, lightweight, and easy to deploy.

Ideal for less complex reporting needs.

Limited advanced features, but good for small/mid-size deployments.

e.KNIME with BIRT Reporting
If you need analytics + reporting, this combo works well offline.

Java-based and flexible but has a steeper learning curve.

3. How are teams handling the recent **Power BI Premium changes** in similar secure or air-gapped setups?

Power BI Premium Gen2 started enforcing more cloud-dependency, including tenant-level activation and usage monitoring.

PBIRS is being maintained but not aggressively updated.

Many organizations are:

1.Freezing on a known-good version of PBIRS.

2.Keeping local backups of installers and documentation.

3.Using hybrid environments (e.g., develop in Power BI Desktop, render on PBIRS offline).

4.Building custom deployment pipelines to safely promote PBIX files from dev (with internet) to prod (air-gapped).

4. Any architectural or deployment best practices for fully offline Power BI environments?

Here's the steps what works well in high-security, offline environments:

Design & Develop in a Dual-Zone Setup

Use an isolated dev environment (that has internet access) to build reports.
Export PBIX files to the offline environment manually (USB, CD, secure transfer tools).
Deploy via PBIRS or equivalent.

Use Version Control for PBIX Files

PBIX is a ZIP format—store the underlying files (.json, .xml, .data) in Git for versioning.
Helps track changes over time even without cloud services

Set Up an Internal PBIRS Architecture

PBIRS on a hardened Windows Server VM.
Local AD authentication for users.
Internal-only email gateway for subscriptions.
Automate dataset refreshes via SQL Agent or PowerShell scripts.

Logging and Monitoring

Enable full local logging on PBIRS.
Monitor CPU/memory usage—PBIRS can spike with complex reports or large data.

Data Modeling Best Practices

Keep models lean. Power BI is memory-intensive, so reduce cardinality, use star schema.
Pre-aggregate data where possible (use SQL Server for heavy lifting).

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

Rama U.

Re: Report Server Implementation

d_gosbell — Mon, 21 Apr 2025 23:40:01 GMT

You can license the on-prem Power BI Report Server either by having SQL Enterprise with SA or by having an F64+ Reserved Instance - see https://learn.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server

Re: Report Server Implementation

d_gosbell — Tue, 22 Apr 2025 04:15:31 GMT

v-venuppu wrote:

and even then, you'll likely hit connectivity issues in a fully offline setup.

v-venuppu - what connectivity issues are you talking about here? I've used PBIRS since 2017 and I've never run into anthing like this.