Power BI provides two options for creating reports with relational and multidimensional data models: Multidimensional and Power BI Tabular.

Multidimensional :

Multidimensional data models are based on the traditional OLAP (Online Analytical Processing) cube structure and are created using SQL Server Analysis Services (SSAS). To use this option, you need to create an SSAS cube and then connect it to Power BI. The cube can be hosted on-premises or in the cloud, and can be refreshed on a schedule or in real-time.

Here is an example of how to create a Power BI report with a multidimensional data model:

* Create an SSAS cube using SQL Server Data Tools (SSDT).
* Connect the cube to Power BI by selecting "Get Data" > "SQL Server Analysis Services" in the Power BI Desktop.
* Select the cube and tables you want to use in the report, and load the data into Power BI.
* Create your report by dragging and dropping fields onto the canvas, and using the Power BI visuals and formatting options to display the data.
Power BI Tabular :

Power BI Tabular is a newer, in-memory data model that is optimized for performance and scalability. This option allows you to create reports using Power BI Desktop, and the data can be refreshed in real-time or on a schedule.

Here is an example of how to create a Power BI report with a tabular data model:

* Connect to your data sources by selecting "Get Data" in the Power BI Desktop. You can connect to a variety of sources, including Excel workbooks, databases, and cloud-based services.
* Load the data into Power BI by selecting the tables and columns you want to use in the report.
* Create relationships between the tables as needed.
* Create your report by dragging and dropping fields onto the canvas, and using the Power BI visuals and formatting options to display the data.