Forum Discussion

Chrisp22o's avatar
Chrisp22o
Frequent Visitor
9 years ago

ODBC connection - Large table

Hi,   I am trying to import a large table from a database that I connect to using an ODBC connection.  I am finding that when I try to query the table and also refresh, it is taking a considerable ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Lots of variables. If the data source provides a Direct Query connection, then you are good. These are pretty well outlined in the data connections in the Power BI data connections. ODBC is the fall back connector for when a more native one is not available.

 

And are you talking about importing all that data into your Power BI desktop file? In that case, I would say that the primary factor is how long it takes to get the same ODBC data connection flowing into PowerBI.com. That should be much faster and also happening in the background (thank you Gateway!) so that you should not really notice or care (e.g. if the data is updating every two hours or so, the data update will all happen behind the scenes and without you need to be monitoring it.

 

Hope this helps.

Scott