Creating an ODBC Connection from Geo SCADA 2021 to Power Query in Excel
EcoStruxure Geo SCADA Expert Forum
Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send InviteCancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Creating an ODBC Connection from Geo SCADA 2021 to Power Query in Excel
I am trying to create an ODBC connection from Geo SCADA to Excel. Excel lives on the Geo SCADA Server machine. I have done this many times in older versions of Excel and Geo SCADA without any issues. I have not tried this since Excel changed it's query interface to "Power Query Editor". Has anyone had success with this?
I recently helped another customer set up an ODBC connection from Microsoft Access to Geo SCADA 2021 and they did not have any issues querying data from the database.
When I attempt this from Power Query in Excel the database schema is displayed fine, and I can navigate the schema and see all of the tables. However, when I try to query data from CDBPoint it just spins forever and the rows never appear. I only have a few points on this system so the query shouldn't return more than 1500 rows. It never errors out. Just spins forever. I have tried displaying data from a number of tables and get the same result. We are somewhat connected, displaying the schema, but cannot retrieve data.