Composite Model Direct Query not showing any data in Service

[Anonymous]

Hi guys,

I'm struggling with the following issue:

I have a composite data model, datasource is an Azure SQL database. One table is connected via direct query, some more are imported.

In Power BI desktop everyting works as expected. When publishing to the Service following error message occurs:

In the Service itself it's said that I don't need a gateway because all my sources are in the cloud.

The effected visuals say that the data couldn't be found.

Am I missing something?

[v-juanli-msft]

Hi @Anonymous

Which version of power bi desktop do you use?

In Azure portal, have you enabled 'Allow access to Azure services' and set server firewall to provide access to client IPs?

Please refer to this document.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

thanks for your reply.I'm using: Version: 2.65.5313.841 64-bit (Dezember 2018)

Yes, both was set up already and as far as i understand this should be all to configure.

That's what is confusing me.

Best

Waldemar