How to enable automatic Power BI reports in an app
To get started, the first step is to enable this feature at an app level. We open the model driven app using the new preview designer.
Next, we navigate to the settings area and turn on the "Enable Power BI quick report visualisation on a table (preview)" setting.
extra prerequisite is that we must enable the TDS endpoint at the environment level. My previous post here provides more
details of this feature.
Finally, we must save and republish the app to apply the changes.
How to view Power BI report visualisations from a grid
From the model driven app, we can now open any grid view and click the "visualize this view" button that appears in the menu bar.
Clicking this button generates the visualisation, which can take
several seconds. The output then appears in a panel. The report includes auto-generated charts and tabular views of the data.
filter and customise the report further using the controls that are
available in the report. Unfortunately, any customisations that we make
will not be saved or retained for future sessions. Nonetheless, it still offers a much better way to explore the data.