Page History
CardioLog Analytics version 4.0.0 or higher provides delivers reports via Microsoft Power BI.
The integration with Microsoft Power BI enables stakeholders and portal administrators to perform quick, on-demand slice & dice actions on their data through intuitive reporting dashboards, monitor create the KPIs that mean the most to them, and search through it all in one glance.
The integration is available for on-premises deployments of Microsoft Power BI.
CardioLog Analytics on-premise with Power BI schematic overview
System Requirements
...
Standard Edition |
...
Dev
Est.
...
1) Power BI Desktop
via import mode
...
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)
...
Desktop App
...
No, if connected via import mode
...
Requires SSAS (option #2)
Consume small amounts of RAM ~1GB
...
PRO
ENT
...
2) Microsoft SQL Server
Analysis Services
Used for "Live connection" mode
for Report server or PBI Desktop
...
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
...
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
...
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
...
STD
PRO
ENT
...
Has its own RLS, so supports many users
+ SSAS can be used if connected
Export options:
- PDF - possible via PowerBI Desktop
- PowerPoint - possible via PowerBI Online, planned for PowerBI Desktop
- Embed to Sharepoint - 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
- File - Report file can be shared across the network
- Excel - 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
Professional Edition | Enterprise Edition | ||
Client | Power BI Desktop* | Power BI Desktop and/or web browser** | |
Server | Power BI Report Server*** | ||
SQL Server Edition | SQL Server 2012/2014/2016/2017/2019/2022 Standard Edition | SQL Server 2012/2014/2016/2017/2019/2022 Standard Edition | |
SQL Instance Memory | Minimum - 8 GB Recommended - 32 GB | Minimum - 16 GB Recommended - 64 GB | |
SQL Server Processors | Minimum - 2 Cores Recommended - 8 Cores | Minimum - 4 Cores Recommended - 16 Cores | |
SQL Storage | Minimum - 80 GB | Minimum - 80 GB | |
Additional Software & Services | SQL Server Analysis Services | SQL Server Analysis Services |
(*) Up to a dataset size of 1 GB.
(**) Access to Power BI reports via a web browser requires a Power BI Report Server. Power BI Desktop version should be optimized for Report Server.
(***) Power BI Report Server is included with the Power BI Premium license and with SQL Server Enterprise Edition with Software Assurance support.