Access to Power BI datasets in composite model

[daaa]

I have a composite model consisting of multiple Power BI datasets with a directquery connection, and some imported data from a SQL database.

The gateway setup looks as follows:

Everywhere it says "Optional - Add to gateway" is the directquery connections to Power BI datasets.

Question:

When I share the report from this composite model, the users cannot see anything, unless I share every single Power BI dataset that is used in the directquery connection, which is quite a chore. Is there any workaround for this? I tried adding a gateway connection for all these optional ones, but could not get it to work.

[daaa]

Hi @lbendlin and thank you for your response.
Could you elaborate why my Sharepoint connection is unfortunate? I understand its related to it showing both under data sources and cloud connections.

[lbendlin]

Generally you don't need a gateway for Online data sources like Sharepoint. There is one exception - when you made the (unfortunate) decision to merge SharePoint data with on-prem data in Power Query (Don't ever do that again!).

After you added the SharePoint query to the gateway you can never ever remove it again. It's a curse.

[lbendlin]

When I share the report from this composite model, the users cannot see anything, unless I share every single Power BI dataset that is used in the directquery connection, which is quite a chore.

If you share a report (via the app!!!) that is based on a composite model including datasets residing in other apps then your report users must register/install both your app and ALL the other apps for these datasets.

Some capacity/tenant admins may allow automatic installation of apps. It would alleviate your scenario somewhat, but this is generally a VBI. 

Your gateway setup is fine. Don't touch that. (Apart from that Sharepoint connection - that is unfortunate.)