In the era of advanced analytics, leveraging data is essential for making informed decisions. Microsoft Fabric, offers a robust framework for data management and analysis. A standout feature in this ecosystem is the capability to effortlessly generate Power BI semantic models directly from a Warehouse.
In this blog post, we will explore the intricacies of this process, its advantages, and key considerations within the Microsoft Fabric environment.
Power BI semantic model
In Microsoft Fabric, Power BI semantic models provide a logical representation of analytical domains with automated creation and inheritance of business logic from the parent lakehouse. Following a star schema, these models empower users to analyse data effortlessly. Integrated seamlessly into Power BI, users can build reports in the web or desktop, ensuring a time-saving and user-friendly experience. The default naming convention aligns with the Lakehouse, enhancing consistency in Microsoft Fabric’s analytical ecosystem.
Creating Power BI semantic models directly from a data warehouse offers several advantages
- Optimized warehouse structures improve query performance for faster data retrieval.
- Direct Power BI to warehouse connection minimizes the need for ETL, ensuring up-to-date reports.
- Live data connections provide real-time insights, updating Power BI reports as warehouse data changes.
- The semantic model reflects the warehouse schema, ensuring data consistency and accurate reporting.
- Warehouse security controls are inherited, enforcing data-level security rules for authorized access.
- Scalable semantic models handle large datasets without compromising performance, allowing seamless growth in Power BI.
How to create Power BI semantic model from warehouse?
Follow the steps to create semantic model from warehouse.
- Launch https://app.fabric.microsoft.com/
- Sign in to Microsoft Fabric with your subscription or trial account. Refer Lesson 3 Getting started with Microsoft Fabric.
- Click on the Navigation pane and click create option on the Fabric homepage.
- Click on the warehouse under Data warehouse to initiate the creation of a new warehouse.
- Enter the name for the new warehouse you wish to create. Click Create.
- Upon entering, you will be directed to the warehouse home page. For this exercise, sample data has been utilized. Click on the sample data option to load it into your newly created warehouse.
- Once selected, all tables from the sample data will be loaded into the warehouse. Now, switch to the reporting ribbon for further actions.
- Within the Reporting ribbon, select “New semantic model.”
- In the following dialog, designate the workspace and select the tables to be included, then proceed by clicking “Confirm.“
- The semantic model has been successfully created under the chosen workspace. Confirm the creation on the workspace page dedicated to the semantic model.
- Several options are available, including auto-creating the report, analysing in Excel, creating a report, creating a paginated report, and more. Click on “Auto-create report” to generate a Power BI report automatically based on the semantic model you have created.
- A Power BI report has been automatically generated, as depicted below.
Default Power BI semantic model
When establishing a Warehouse or SQL analytics endpoint, an automatic creation of a default Power BI semantic model takes place, identifiable by the (default) suffix.
This default semantic model is accessible and updated through the SQL analytics endpoint, adapting to alterations in the associated Lakehouse or Warehouse. Additionally, querying the default semantic model is possible through cross-database queries initiated from a Warehouse.
Synchronise the Default Power BI Semantic Model
To modify this default behaviour, you have the following options
- Click on the settings icon, and manually enable the “Sync the default Power BI semantic model” setting for each Warehouse or SQL analytics endpoint in the workspace. Note that this action will restart the background sync, incurring certain consumption costs.
- Navigate to the Reporting tab in the ribbon bar and click on “Manage default semantic model” to manually select tables and views for addition to the semantic model.
Note: If not using the default Power BI semantic model for reporting, manually disable the “Sync the default Power BI semantic model” setting. This prevents automatic addition of objects, saving on Onelake consumption costs by avoiding background sync triggers.
Automated Semantic Model Update
You can effortlessly update the semantic model by clicking “Automatically update semantic model” under the Reporting tab.
Access the default semantic model
To access the default semantic model, navigate to the workspace. Locate the semantic model that corresponds to the name of the warehouse you created. Click on the name of the semantic model to load it.
Certain actions, such as “Open data model,” have been disabled or greyed out.
| Tags | Microsoft Fabric |
| MS Learn Modules | |
Test Your Knowledge |
Quiz |