One of the restrictions is that, when utilizing a live connection like in OLAP cubing in Power BI, creating measures at a report level is relatively limited because of the nature of the live connection. Below is an explanation and some feasible alternatives on how to work around it:
The first berthing matter:
Only live queries in OLAP modes, like SQL Server Analysis Services or Azure Analysis Services, directly access the cube within Power BI; there is no need for data importation. The restriction is that report-level measures cannot be created, as the measures are supposed to be defined in the OLAP model. Dependency on OLAP Model: All the measures need to be in the cube's data model because Power BI is just the visualization layer, and it cannot manipulate the data schema or add calculated fields.
2. Now we have many other options:
Ask the cube developers. Collaborate with OLAP cube admins or developers to bind the necessary measures directly into a cube, making the measures centrally managed and optimal for reuse. This also prevents theft.
Use calculated columns or measures inside Power BI if switching is possible in DirectQuery or import mode. You can define additional or supplemental report-level measures in Power BI. This may even include sending a direct connection of live devices so it is still not within the stretched mode.
Convert to a mixed mode: If you want, consider whether composite models (DirectQuery for the AS model) for the OLAP source are possible. This would combine live-connection data with additional datasets in Power BI. Potentially, further measures can then be locally created.
Concrete Situations In Which This Is Possible
Tabular Models: For some instances like these, an OLAP cube becomes a tabular model, and Power BI has the feature of Direct Query for AS models, which allows the creation of report-level measures while connecting to the live cube.
Hybrid Models: Sometimes, hybrid solutions, which essentially consist of importing with live connections, are possible; therefore, report-level measures should be created for imported and non-live connections. Ct portions.
As you are restricted on your live connection to Power BI, you should contact the OLAP cube administrator while examining composite models. Thus, composite models can be considered from the point of view of individual Reporting requirements.
