Solved: Re: Dealing with huge database

Anonymous · ‎05-31-2018

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 · ‎06-01-2018

@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

View solution in original post

Greg_Deckler · ‎05-31-2018

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎05-31-2018

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

Anonymous · ‎05-31-2018

@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 · ‎05-31-2018

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

Anonymous · ‎05-31-2018

@Anonymous,

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

Regards,
Lydia

Anonymous · ‎06-01-2018

@Anonymous,

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

Anonymous · ‎06-01-2018

@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