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):   Gateway Settings shows that is online: You are good to go Data Source Settings shows Connection successful The measures...
Need Help
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

    • Marios's avatar
      Marios
      Frequent Visitor
      8 years ago

      The problem still exists. I removed the gateway, reinstall it but nothing changes. Both measures and dimension appears in the fields panel, Gateway Settings “Online: you are good to go.”, Data Source Settings “Connection Successful” BUT “Can’t display the visual. See details” and “There was a data source access error. Please contact the gateway administrator”

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

        Hi Marios,

        Please open a support ticket on the bottom of this page to check your own data background since we have no power to check customer's data.

        Best Regards,
        Angelia