Forum Discussion

kapilmahajan's avatar
kapilmahajan
Regular Visitor
9 years ago

Issue in Dashboard loading in Import Mode

Hi     I have a dashboard with import mode and its fetching the data from Azure SQ Db and sometime the dashboard is loaded in seconds and sometimes it takes a long time (minutes) to load. Not sure i...
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool,

 

Now u r in cloud it mean Microsoft Server so don't worry about RAM and other hardware configuration.

 

U have to work on Datawarehouse side and Power BI Desktop. 

 

Example :

 

Check your DAX Code performance using DAX Studio.

Reduce and remove unwanted column etc....

kapilmahajan's avatar
kapilmahajan
Regular Visitor
9 years ago

HI Baskar

 

My taskbar shows 200 M RAM taken by chrome so was thinking may be browser is caching the data.

 

Also what is the reason for the report taking time first time and not next time.

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    First time it will getting the data from source , that u r correct .

     

    Once it was loaded then it was stored in cache bec of it was loaded at second time is faster then first time.

     

    My Suggestion :

     

    1. Try with latest browser, even check with Microsoft Edge.

     

    2. Give high importance on Data Modelling  part, Like DAX Optimization.

     

    3. Reduce your data Size.

    • kapilmahajan's avatar
      kapilmahajan
      Regular Visitor
      9 years ago

      I am using some slicers and I saw that Slicers reduce the performance. Are there any other tips for increasing the performance.