Box 1: use Analyze in Excel -
Build permission applies to datasets. When you give users Build permission, they can build new content on your dataset, such as reports, dashboards, pinned tiles from Q&A, paginated reports, and Insights Discovery.
Users also need Build permissions to work with the data outside Power BI:
To export the underlying data.
To build new content on the dataset such as with Analyze in Excel.
To access the data via the XMLA endpoint.
Box 2: grant the Read permission for
The Corp group has read, share and rebuild permissions.
As a property of the Power BI App, you can allow users to share the app and underlying dataset with share permissions.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions https://data-marc.com/2021/07/30/transform-a-local-into-a-global-power-bi-solution-request-access-to-content/