Forum Discussion

josn0w's avatar
josn0w
New Member
10 years ago

Data won´t load from Access Database

When trying to load data (11 Million Lines) from an access database the process "CefSharp.BrowserSubprocess.exe" stays for more than 30 minutes by 25% CPU-Load.

Afterwards the data didn´t even load properly into an diagram.

 

Any ideas?

8 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    So, does the data load into the model or no?

     

    Sorry, side note, 11 million rows in an Access database...seriously? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hello josn0w

     

    Can you tell us the hardware configuration for the computer using Power BI desktop because it sound like and memory limits.

     

    And by the way, I quite agree with Greg_Deckler about the number of record and the database...

     

    Sebastien

    • josn0w's avatar
      josn0w
      New Member
      10 years ago

      Anonymous

      Hardware:

      Processor: i7-26420 @2.80 GHz

      RAM: 8 GB

      64Bit

       

      Greg_Deckler

      It was some demo data and yes there are 11.000.000 lines...

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hello,

         

        I think there's an issue with you database design and optimization.

        I've got a different configuration VM (64 bits, 4 Go RAM) and try to use it for direct querying a 6.000.000 rows tables from Sql Server.

        I was facing that CefSharp.BrowserSubprocess.exe hang when I tried to access my table.

        I optimize it with a ColumnStore Index and everything was quite fine.

         

        I know you cannot use this king of index with Access, but I think you should try to optimize your tables with indexes and aggregate tables.

         

        Let me know if it help you.

         

        Sébastien