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

I have few questions for u dude.

 

1. Are u saying the entire dashboard Loading  is slow or any particular visual is loading slow ?

 

2. Did u used any Custom visuals on your dashboard ?

 

Suggestion :

 

Try with latest browser . Edge or Chrome latest updated one.

If custom visuals there pls delete that and check once.

 

Let me know

kapilmahajan's avatar
kapilmahajan
Regular Visitor
9 years ago

HI Baskar

 

All the visuals take time.

 

I have not used any custom visual.

 

Can somebody help me with how much RAM does the app take?

Is the dashboard loaded at runtime in the browser at first time and then cached in browser.

 

I have seen that the first time I load the report it takes time but next time its fast.

 

Can someone explain how the Import publishing works till the report is loaded in browser.

  • 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.