Forum Discussion

lemaribdb's avatar
lemaribdb
Icon for Helper II rankHelper 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.

lemaribdb's avatar
lemaribdb
Icon for Helper II rankHelper II
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.