Forum Discussion

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?

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

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

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
Not applicable
8 years ago
Anonymous,

I was still unable to extract any data with my sql statement below
- Anonymous
  Not applicable
  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