Forum Discussion

GJA's avatar
GJA
Icon for Helper II rankHelper II
2 years ago

Dax & Direct Query Performances

Hi,    I noticed that there are performances issues when I create measure when I am connected to date source (sql server) in direct query mode.   For sample if I put a column from a fact table an...
Direct Query Performance DAX Measure
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
2 years ago

Direct Query does it's processing on the source database. Use Import mode as your first option unless you have good reasons not to.