Dealing with huge database

[Anonymous]

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?

[Greg_Deckler]

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

[Anonymous]

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

[Anonymous]

@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]

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

[Anonymous]

@Anonymous,

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



Regards,
Lydia

[Anonymous]

@Anonymous,

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

[Anonymous · Accepted solution]

@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