Page History
...
The integration is available for on-premises deployments of Microsoft Power BI.
System Requirements
| Standard Edition | Professional Edition | Enterprise Edition |
Platform | 64-bit | 64-bit | 64-bit |
Operating System | Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched) | Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched) | Dedicated Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)
|
Application Memory* | Minimum - 4 GB Recommended - 8 GB | Minimum - 8 GB Recommended - 16 GB | Minimum** - 16 GB Recommended - 32 GB |
Processors* | 4 Cores | Minimum - 4 Cores Recommended - 8 Cores | Minimum** - 8 Cores Recommended - 16 Cores |
SQL Server Edition | Microsoft SQL Server 2012/2014/2016/2017 Enterprise Edition (fully patched) | Microsoft SQL Server 2008/2008 R2/2012/2014/2016/2017 Standard Edition (fully patched) | Microsoft SQL Server 2008/2008 R2/2012/2014/2016/2017 Standard or Enterprise Edition (fully patched) |
SQL Instance Memory | 4 GB | Minimum - 8 GB Recommended - 16 GB | Minimum** - 16 GB Recommended - 32 GB |
SQL Server Processors | 4 Cores | 8 Cores | Minimum** - 8 Cores Recommended - 16 Cores |
SQL Server Storage: |
|
|
|
| SQL System Disk (Mirrored) | 10 GB | 10 GB | 10 GB |
| SQL Page File Disk | 10 GB | 10 GB | 10 GB |
| SQL Database Disk | 20 GB per year | 60 GB per year A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs | Maximum 600 GB per year A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs |
| SQL Transaction Log Disk | 1 GB | 5 GB A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs | Minimum** - 50 GB Recommended - 100 GB A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs |
| SQL Temp Database Disk | 20% of Database Disk size | 20% of Database Disk size Recommended - A separate physical hard disk, preferably solid-state drive (SSD) | 20% of Database Disk size Recommended - A separate physical hard disk, preferably solid-state drive (SSD) |
| SQL Temp Database Log Disk | 1 GB | 5 GB | 5 GB |
| SQL RAID | RAID 10 or similar | RAID 10 or similar | RAID 10 or similar |
Additional Software & Services |
|
|
|
* This refers to hardware allocated for the CardioLog application pool and services, not for the CardioLog SQL server
| Option | Dev Est. | System Requirements | Additional Costs Involved | Access Method | Customer Size | Storage Limits | Permissions Support |
|---|---|---|---|---|---|---|---|
1) Power BI Desktop via import mode | 0 | Client App Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2 Windows Server 2012, Windows Server 2012 R2 Internet Explorer 10 or greater Available for x64 or x86
In import mode consumes a lot of RAM (depending on dataset site) | Free | Desktop App
| STD | 1GB | No, if connected via import mode |
| via Live connection mode | Requires SSAS (option #2) Consume small amounts of RAM ~1GB | PRO ENT | No | RLS via SSAS | |||
2) Microsoft SQL Server Analysis Services Used for "Live connection" mode for Report server or PBI Desktop | 5 | Server App Recommended: 16 Cores, 64 gigabytes of RAM Minimum: 64-bit dual-core processor, 3 gigahertz, 8 gigabytes of RAM At least 80 gigabytes of storage | SQL Server Enterprise - $14,256 | Desktop App or Web access (with option #3) Used as intermedia for large customers Allows to load server RAM instead of client RAM | PRO ENT | No | Allows to have RLS (row-level security) So basically allows having users support |
3) Power BI Report Server Used as GUI Power BI Online substitutor | 5 | Server App Recommended: 4GB RAM, x64 2.0GHz processor, Minimum: 1GB RAM, x64 1.4GHz processor | Comes with Power BI Premium: ~5000$ monthly OR SQL Server Enterprise with Software Assurance Support Cost is 25% from MS server products | Web access | STD PRO ENT | No | Has its own RLS, so supports many users + SSAS can be used if connected |
Export options:
possible via PowerBI Desktop
possible via PowerBI Online, planned for PowerBI Desktop Possible in PowerBI Online and Sharepoint Online, because we can embed link to Power BI
Online Service, which will render the result.Link - Can be a link to report
on PowerBI Report Server Report file can be shared across the network possible via PowerBI Desktop
Power BI report server prerequisites:
- Power BI desktop optimized for Report Server should be installed
- The report should be saved by this app as optimized for Report Server before uploading it to Report Server
While saving we should specify server URL and connection to the server should be established. So there's no option that we can generate this report for the customer.- The latest release of Power BI desktop optimized for Report Server was on May, which means that we can open reports only generated by May version of Power BI desktop