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 working fine on Power BI desktop but when I publish it to the Power BI Service and open it the error "Could not load the model, check the connection to the server and try again" pops up.

I close the error text box and the report opens, I can navigate in the different pages and see the static text boxes inserted and pictures and shapes but every visual that contains data remains white.

 

Does anyone has an idea from where could the problem come from ?

 

Thanks in advance.

Best regards,

Cado

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

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Could you please share more detailed information about these issues? (e.g. snapshot, error message, configurations...) 

     

    Best Regards,

    Yuna

    • Cado_one's avatar
      Cado_one
      Resolver III
      5 years ago

      Hi Anonymous 

       

      Here is the error message, it says "impossible to load the model associated to this report. Check the connection to the server, then try again"

       

      My credentials are okay

      The Data source is a Power BI dataset connected in DirectQuery mode, the dataset takes its source from Azure Analysis services database

       

      When I close the error textbox I can access the report but all visuals that uses data are empty

       

      Do you need more informations ?

  • 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

  • Jcarterdean's avatar
    Jcarterdean
    Frequent Visitor
    5 years ago

    I have possible had users with similar issues(not myself) is it possible it requires build permission on the underlying direct queried dataset not just viewer?

     

    the only other thing I could put it down to is that since it is direct query it would be subject to capacity throttling and query limits?