cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mbrough Member
Member

Composite Model Different Source Slow

Hi,

 

I have a composite model from a number of SQL databases.

 

I have a fact table (direct query) and an aggregated fact table (import) from one database.

 

I have a calendar table (dual mode) from another database.

 

I'm finding the queries are very slow when drilling down by the calendar table (with measures from the fact table). Is this because of the different data sources?

 

Regards

 

Mike

3 REPLIES 3
Community Support Team
Community Support Team

Re: Composite Model Different Source Slow

Hi @mbrough,

 

Did you write complex measures in your scenario? You can use DAX Studio to run traces against your measures in your data model to find the issue

https://daxstudio.codeplex.com/

 

See this blog as a start point of how to use this feature

http://sqlblog.com/blogs/marco_russo/archive/2016/11/01/new-server-timings-features-in-dax-studio-2-...

 

Quite often slow queries often relate to poorly written measures (I used to struggle with this a lot when I first started using Power BI).

Use this tool to investigate what measure is causing you issues and maybe post that query on here if you can't work out how to make the query more efficient after some googling. 

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support Team
Community Support Team

Re: Composite Model Different Source Slow

Hi @mbrough ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
mbrough Member
Member

Re: Composite Model Different Source Slow

Hi

The measures are very simple. I.e CALCULATE(SUM(....

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)