query time
1 Topic
DAX Query Performance in source dataset vs report
Dear PBI community, I have an issue with load times. I have source dataset with report and a report that uses live connection to this datset/semantic model. Orignally, I had my measure in the undeerlying report that uses the live connection, the query timing was pretty good, no noticable load time. But when I moved my measure to the source dataset, the timing in the underlying report is more than horrible. From 1 second (and it still is 1 second when using the exactly same page/visualizations in source dataset) to 20 second, making the report unusable. Is that something common I was unaware of? When I take the query and run it in Dax Studio, it's as fast (or faster) as in when ran in the source dataset. I thought my DAX is getting to complex but since it runs pretty fast when in source model/report (and was pretty fast when the measure was in underlying report), I feel a bit lost.Solved689Views0likes3Comments