Forum Discussion

lemaribdb's avatar
lemaribdb
Helper II
2 years ago
Solved

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 un...
Query Time
  • lemaribdb's avatar
    lemaribdb
    2 years ago

    I think I've found the solution, it was more obvious then I thought.
    The queries were fast using dax studio or measures directly in my source model. But not in the underlying report.
    The measures in source mode or dax studio are made to localhost data, where the underlying report connect to server nontheless. It was just the company server acting up on this day, it works normally today.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lemaribdb ,

Regarding your question, is the connection mode of the report 'Direct Query'?

In 'Direct Query' mode, data query and calculation are completed in the data source, and the speed depends on the performance of the database. You can try to reduce the amount of single query or use a composite model to improve performance.

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,
Wenbin Zhou

lemaribdb's avatar
lemaribdb
Helper II
2 years ago

Hi, sadly, as I mentioned in my initial text, I'm using live connection mode 😞