Forum Discussion

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    9 years ago

    Hi there,

     

    What is your data source? Are you using import data in PowerBI? How big is your data set?

     

     

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      Hi Pratima

       

      Reduce the amout of data you are bringing in.  eg, remove unecessary columns and rows in the Query Editor if possible.  Convert any columns you have that are full DateTime to just Date, and have a separate column for Time if you need.

    • Pratima's avatar
      Pratima
      Advocate II
      9 years ago

      Hi Dear,

       

      My data source is SQL Server having around 600M  records are there, how to deal in Power BI desktop.

       

      And how to deal Big Size Data.

       

      Thanks,

      Pratima

      • parry2k's avatar
        parry2k
        Super User
        9 years ago
        You should use direct query instead of import data in powerbi.
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Pratima,

     

    1. Does this error throw before? Which data source do you connect to?

    2. Please run PERFMON to check the memory and other resources, also run PROCMON check if any other resource is problematic.

    3. Run the latest desktop version 2.45.4704.722.

    4. Try to reduce data model size as suggested by other members.

     

    Best Regards,
    Qiuyun Yu