Composite model with live connection - "There is no gateway access" on the service

[TrevLc]

Hi,

I am able to create a composite model in Desktop and can see all the data I need to see (I am an admin of the workspace).

It creates a direct query connection to Azure Analysis Services.

When I publish the report to the service, my visuals stop working, and I get an error saying

"There is no gateway to access the datasource...."

Does this mean I need to set up a  gateway connection for every single report I want to connect to?

This seems like a massive burden, as I have hundreds of reports I could live connect to and create composite models with.

Is there a way I can do this without having to set up a gateway connection?

[TrevLc]

Thanks for your response.

I am able to create a composite model by using a Power BI dataset, which creates a direct query connection.

(I think it is a preview feature that needs to be turned on Solved: From live connection to composite model - power bi... - Microsoft Fabric Community)

The issue I am facing is, each time I connect to a new dataset, I need to configure a new gateway connection, which is not practical.

Is there a way to set up one gateway connection that works for all datasets?

[v-binbinyu-msft · Accepted solution]

Hi @TrevLc ,

So far, to my knowledge, there is no way to achieve it.

The Power BI Dataset you connected with Direct Query connection should had configured the gateway connection before, when you connect it to create composite model and publish it to Power BI Service, you need not configure the gateway connection.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-binbinyu-msft]

Hi @TrevLc ,

So far, to my knowleddge, Power BI Composite mode are created by mix Import and DirectQuery modes, or integrate multiple DirectQuery data sources. Live Connection is not support.

If your have on-premise data source , you need to configure gateway, you just need configure the gateway connection for the composite mode dataset.

For more details, you can read related document: Dataset modes in the Power BI service - Power BI | Microsoft Learn , 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.