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

Hi Anonymous ,

 

Could you please tell me that is your strorage mode "Direct Query" in the bottom right corner of the screen of your Power BI desktop?

Have you check your dataset settings and gateway managements if they are configured correctly?

 

Best Regards,

Yuna

 

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