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 if this what could be the issue. Is there a way to improve performance. What are the things the performance is dependent?

8 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hikapilmahajan,

     

    As you said, it takes seconds and sometimes it takes a long time (minutes) to load, then the issue can be caused by several factors.

     

    • Client issue. You computer may run lots of other application that takes most of memory at loading data time.
    • Network issue.
    • Server issue. You datasource my be connected by many clients and query data at the same time.

     

    Regards,

    Charlie Liao

    • kapilmahajan's avatar
      kapilmahajan
      Regular Visitor
      9 years ago

      Thanks Charlie.

      I checked and the i tried closing all other applications and running only the browser. But still its taking time.

      The network connection is not an issue as the connection is 100 MPBS.

      Also the data source I am using to connect is the one I created for this report and no one is using it.

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident 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
        Icon for Resident Rockstar rankResident 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....