Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dashboard in Direct Query on SSAS Tabular : Conceptual Schema step very slow

Hello everyone, We have Power BI Report Sevrer, with direct query dashboards on SSAS Tabular. When we click on a dashboard, it takes about 30 seconds to display because of a step called "Co...
Conceptual Schema
DirectQuery
PBIRS
PowerBI Report Server
SSAS
SSAS Tabular
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
5 years ago

I double checked on our production server, we do most of our core reports over SSAS and the conceptualschema call only took between 0.7 to 1.5 seconds on the reports I tested. You might need to raise a support ticket with Microsoft as this is appears to be an issue with the internals of PBIRS.

  • vivien57's avatar
    vivien57
    Icon for Super User rankSuper User
    5 years ago

    When I do the test with the same data source (SSAS Tabular) but with a PBIRS installed on my computer, I also have times lower than 1 second...

    Do you have any idea where it can come from ?

    • RonaldTop's avatar
      RonaldTop
      New Member
      2 years ago

      Hello, despite being it an old question, did you ever resolved this, without direct SQL auth?

      Thanks!

      Ronald