Thank you Tim. I appreciate you taking the time to test! Our IT team found a newer version of the Power Query plug-in and installed in on the users computer. The ODBC connection now works and we are getting results. We have other issue to resolved with Power Query, but those are just Expression errors (query logic) so I think we’re on track now.
Best! Kirk > On Mar 17, 2017, at 5:20 PM, Timothy Penner <[email protected]> wrote: > > Hi Kirk, > > I did a really quick test with Power Query (32 bit) with Excel 2010 (32 bit) > connecting to 4D Server v15.4 (64 bit) using the 4D ODBC Driver (32 bit). > https://www.microsoft.com/en-us/download/details.aspx?id=39379 > > For me it worked, but my test database only had 1 table with 3 fields and 1 > record. > I then added a second record and refreshed the data on the excel spreadsheet > to get two records. > > This was the first time I used Power Query so I don't know if I am doing the > same thing you are doing... > > I have no idea what HY02470 is, it doesn’t seem to be coming up in my online > searches. > > If you open a case on taow.4d.com we can get you more dedicated help on > troubleshooting this. > > -Tim > > > Timothy Penner > Technical Services Engineer > > 4D Inc > 95 S. Market Street, Suite #240 > CA 95113 San Jose > United States > > Telephone : +1-408-557-4600 > Standard : +1-408-557-4600 > Fax : +1-408-271-5080 > Email : [email protected] > Web : www.4D.com > > ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
