Forum Discussion

Marios's avatar
Marios
Frequent Visitor
8 years ago

Can't Display the Visual (DirectQuery)

Hallo, 

 

I have created a connection to the cubes (with DirectQuery):

 

  1. Gateway Settings shows that is online: You are good to go
  2. Data Source Settings shows Connection successful
  3. The measures and dimensions appears under the filters (as normal)

 

BUT when I try to create a report (I have try almost all visualizations) with measures or dimensions, the report created but indicates that ''Can't Display the visual. See details”. Also add the top of the page there is a warning “There was a data source access error. Please contact the gateway administrator. 

 

Any suggestions?

 

Thanks

Need Help

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Marios "Cubes" - I assume you are connecting to a SSAS multi-dimensional instance? Is it with all your data, or just certain elements? Asking because there are certain un-supported features like Calculated Members etc... Reference here

    • Marios's avatar
      Marios
      Frequent Visitor
      8 years ago

      Yes with the term cubes i mean SSAS.When i create the reports using power BI desktop i dont have this issue but when i publish them the issues appears.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi Marios，

        It's weird, I test it in my local computer, all things works fine. Please check if you sign in the data gateway and power BI service using the same account? And update the gateway to latest version.

        Best Regards,
        Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Marios,

    Have you resolved your issue? Please refer to the information Anonymous posted, and share more details for further analysis.

    Best Regards,
    Angelia

  • malkalbani's avatar
    malkalbani
    Regular Visitor
    3 years ago

    I am facing the exact same issue. The direct query display the visual in the desktop version but when published it gives this error (can't diplay visual). All data sources and connection seem to be good. Any idea what might have caused this?

    • malkalbani's avatar
      malkalbani
      Regular Visitor
      3 years ago

      Here is error details

       

      Activity ID: f1c4469e-62aa-4e85-94f0-1389ae899655
      Request ID: bf7b5c81-d2cf-c72a-4df5-972900312d95
      Correlation ID: 64d83162-2078-7bc2-4efe-c081b1a80c07
      Time: Tue Jan 31 2023 13:06:35 GMT-0500 (Eastern Standard Time)
      Service version: 13.0.19958.49
      Client version: 2301.4.12022-train
      Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/

    • aj1973's avatar
      aj1973
      Community Champion
      3 years ago

      Hi malkalbani 

      What visual is it? can you send a screenshot from Desktop and from the service!

      • malkalbani's avatar
        malkalbani
        Regular Visitor
        3 years ago

        Hi, 

         

        Solved. I had to modify the data gateway to link the sharepoint data source. I have data model that utilizes sharepoint and two SQL server connecitons. 

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Was this resolved? I am facing the same issue and cannot change the gateway connection.

     

     

    My report consists of a SharePoint and DirectQuery connection:

     

    I can see all the visualizations just fine in Power BI Desktop but when I publish, I cannot see the Matrix which has fields from SharePoint and the Direct Query. When published, I can see a table with just SharePoint file fields and another with just DirectQuery fields. The issue only persists when they are in a visual together.

     

    Please help