topic Re: Dashboard in Direct Query on SSAS Tabular : Conceptual Schema step very slow in Report Server

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

Anonymous — Thu, 01 Jul 2021 08:47:04 GMT

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 "ConceptualSchema". (see screenshot).

I understand that it loads the SSAS model metadata, but 30 seconds each time it opens is unacceptable.

Do you have this problem? Did you solve it?

Thank you in advance for your help,

Have a nice day,

Vivien

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

d_gosbell — Thu, 01 Jul 2021 10:06:41 GMT

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.

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

vivien57 — Thu, 01 Jul 2021 11:34:19 GMT

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 ?

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

vivien57 — Thu, 01 Jul 2021 14:33:00 GMT

It seems to be the same cause as this:
https://community.powerbi.com/t5/Report-Server/Report-Server-portal-loading-extremely-slow/m-p/1932957#M19972

Indeed, if I do a direct query dashboard on SQL Server with database authentication, the "ConceptualSchema" step takes less than a second. If I switch to Windows authentication then it takes a long time.

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

d_gosbell — Thu, 01 Jul 2021 23:36:57 GMT

vivien57 wrote:

If I switch to Windows authentication then it takes a long time.

So that could point to an issue with Active Directory in your environment. I think raising a support ticket with Microsoft is your best course of action. And the "ConceptualSchema" call is an internal API I'm not aware of any documentation on it that could help address performance issues, but the support engineers would have access to the source code to help them toubleshoot this.

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

RonaldTop — Fri, 01 Mar 2024 13:47:57 GMT

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

Thanks!

Ronald