Power BI Sample Report (DirectQuery) #
Power BI uses a semantic model which is a structured representation of data that organizes and simplifies raw data for reporting and analysis. It includes elements like data connections, transformations, calculations, and relationships, serving as a single source of truth for reports across an organization.
Power BI semantic model modes refer to the different ways data can be connected and utilized within Power BI. The three main modes are Import, where data is loaded into memory for fast access; DirectQuery, which queries data in real-time without storing it; and Composite, which combines both Import and DirectQuery methods for flexibility.
The cBI Focus Planner currently supports both Import and DirectQuery mode. However, the sample report in the Microsoft AppSource uses the Import mode which works fine in Power BI Desktop. If you want to publish the report to the Power BI service and test it in the web, download the below sample report which uses the DirectQuery mode. See this section for details on the different behavior depending on the Power BI environment and license.
DownloadDocumentation PDF Export #
Below you can download the PDF version of the complete documentation.
Bash Script for Whitelisting Power BI service IP addresses #
In the section “Explicit Whitelisting of individual IP addresses” a method of individually whitelisting the IP addresses in the Azure SQL server in the Azure Portal is described. This is also possible using a series of bash command. Below you can download a .zip-file containing an example for such a bash script.