Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Visuals not loading on Service with DirectQuery connection to a Power BI dataset (AAS)

Hi all,   I write this topic because I'm facing an issue with Power BI Service. I have reports connected to Power BI datasets in DirectQuery mode (thanks to the new feature in preview). It is work...
Interesting Links
Need Help
Tutorial Requests
  • Cado_one's avatar
    Cado_one
    5 years ago

    Hi Anonymous 

     

    Finally it turns out that my company is blocking the possibility to use DirectQuery for Power BI datasets because this is a feature in preview so there could be updates to come which would make my work useless...

     

    Do you know when this feature will be accepted as an official one ?

     

    Regards,

    Cado

Cado_one's avatar
Cado_one
Resolver III
5 years ago

Hi Anonymous 

 

Yes I have the DirectQuery mode in the bottom right corner of my Power BI desktop.

 

When I go the the settings of the dataset on PBI Service it says that a gateway is not needed because all data sources are in the cloud.

My Oauth2 credentials are okay too.

Is there an other setting I forgot ?

 

Regards,

Cado

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Thanks for your reply. 

Can the related report of Power BI Dataset used as a data source be successfully opened? Are you the owner of this Power BI dataset?

Does it need to reset credentials?

 

Best Regards,

Yuna

  • Cado_one's avatar
    Cado_one
    Resolver III
    5 years ago

    Anonymous 

     

    I am the owner of the local model of the dataset (created thanks to DirectQuery mode) but I'm not the owner of the Power BI dataset used as data source.

    I just replaced the "none" by "organizational" in the credentials setting and now I have the visuals displayed in Service but the data is stil not accessible it gives me this error

    When I click "see details" it says "impossible to extract data from this visual"

     

    I tried to connect on desktop to this dataset and it returns this error

     

    Regards,

    Cado

    • Cado_one's avatar
      Cado_one
      Resolver III
      5 years ago

      Hi Anonymous 

       

      Finally it turns out that my company is blocking the possibility to use DirectQuery for Power BI datasets because this is a feature in preview so there could be updates to come which would make my work useless...

       

      Do you know when this feature will be accepted as an official one ?

       

      Regards,

      Cado