Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Composite Model Direct Query not showing any data in Service

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?

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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