Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dealing with huge database

Hi,   I'm dealing with a 2tb database and have tried few times to load it but end up unsuccess. What can i do with it?
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Do you need all the columns of your database? I would recommend you specify required columns using SQL statement like "select col1,col2 from mydata.link_bi_betslips limit 5", and enter timeout value.




    Regards,
    Lydia

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

I would recommend a Direct Query (Live) connection to that large of a database.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Greg_Deckler, my database is in MySQL. I can't find the option for me to perform Direct Query. Below is my view:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      There is no DirectQuery option for MySQL, in your scenario, I would recommend you write specific SQL statement to import required columns and rows.

      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous, can you show me where and how to write the SQL statement in Power BI to import required columns and rows?