Forum Discussion
Dashboard in Direct Query on SSAS Tabular : Conceptual Schema step very slow
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.
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.