Forum Discussion
ODBC connection - Large table
Hi Scott,
Thanks for your reply. I could not see the option to add a Direct Query connection from an ODBC source, you can do from SQL Server.
Im selecting the table to import but then select Edit in the wizard and use the filters on the necessary columns to try and replicate my SQL statement that I previously used for this type of report in Crystal Reports. I have yet to install the Gateway on one of my servers but when I do as you mention it should run in the background.
Regards,
Chris
Just to confirm, is this all using Power BI Desktop? And what database are you connecting to? e.g. SAP HANA? SQL Server?
- I'm using Power BI desktop with a Pro licence. I'm using my odbc connection to connect to a Progress database
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