Forum Discussion

rbhattacharya's avatar
rbhattacharya
Helper I
5 years ago
Solved

Improving Data Load time / Optimization features for PBIX File

Hello,   We have a 6MB PBIX file (Financial accounting dashboard) which consists of several complicated merged SQL views as data source. The dashboard is an exact replica of an excel sheet which ha...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    rbhattacharya I would see this is more of optimizing your SQL views? Also, are you using DQ or Import? if it is an import then I guess data load takes time when it refreshes, is it slow (if using import) when the user interacts with the report? If that is the case then you need to look into your model and table reelationships and also the DAX, and use a performance analyzer to understand which DAX is slow and start from there.

parry2k's avatar
parry2k
Super User
5 years ago

rbhattacharya I would see this is more of optimizing your SQL views? Also, are you using DQ or Import? if it is an import then I guess data load takes time when it refreshes, is it slow (if using import) when the user interacts with the report? If that is the case then you need to look into your model and table reelationships and also the DAX, and use a performance analyzer to understand which DAX is slow and start from there.