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

Just to confirm, is this all using Power BI Desktop? And what database are you connecting to? e.g. SAP HANA? SQL Server? 

Chrisp22o's avatar
Chrisp22o
Frequent Visitor
9 years ago
I'm using Power BI desktop with a Pro licence. I'm using my odbc connection to connect to a Progress database
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Got it. So when you publish your report to the PowerBI service (powerbi.com), the data connection using ODBC will all happen in the background, and you will not have to really worry too much about the timeliness of it (though I do believe there are upper limits to the data size you can connect to, etc, so you might need to see if you surpass those limits). There are often some delays when connecting your power bi desktop file to your data source. It also happens with oData feeds. But that is only really a pain during development. Once you publish your report as intended, then the speed and latency issues should go away.

     

    And btw, you are not the only one clamoring for better connections to Progress. Here is an idea over that you can put your votes into the help raise the awareness of the need for the development team - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7444396-we-need-to-be-able-to-connect-to-a-progress-opened

     

    Btw, if this answers your question, go ahead and please mark this as the solution. That helps keep the forums clean.

     

    Thanks, Scott