...
Connect the semantic model to Power BI Desktop using Spark SQL connection.
Click the Model icon and expand the table that has been added to the application using this SQL connection.
You will see the list of dimensions and measures in the table, as shown in the following figure.
Go to the Kyvos Web portal and open the same semantic model, which is connected to the Power BI. Click and verify the dimensions and measures in the semantic model.
Go to Power BI, and click any element in which you want to create a hierarchy. Click the three dots alongside the element name or right-click the element and choose the Create hierarchy option. A hierarchy is created with the selected element's name.
You can rename the hierarchy as needed. For this, double-click the hierarchy’s name and edit it as you want.
To create the levels in a hierarchy, right-click any other element you want to add, and choose the Add to hierarchy option.
You will see the list of existing hierarchies. Choose the hierarchy to which you want to add the element.
The elements added to hierarchies need to be hidden. For this, you can either mark the Is hidden as Yes from the Properties.
Alternatively, click the hide icon corresponding to the name of the element.
Click any hierarchy, write the folder name in the Display folder field, and press Enter. The hierarchy is added to the folder.
To add attributes in the folder, click any element you want to add as an attribute and write the folder name (where you want to add the attribute) in the Display folder field in Properties and press Enter.
Select an element or multiple elements and give the folder name in the Display folder field in Properties. This adds the measures to the folder.
Measures can be further added to a folder. Select any element you want to add to a measures folder, enter the same folder name in the Display folder field, and press Enter.
Repeat the steps until you get the cubesemantic model's final representation in the Power BI report.
...