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

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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      You can input SQL statement in the highlighted textbox. You can firstly test the SQL statement in MySQL workbench,



      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

         

        I was still unable to extract any data with my sql statement below