FoxPro Programming
Feeding VFP data to Power BI with VFP's ODBC driver
Gravatar is a globally recognized avatar based on your email address. Feeding VFP data to Power BI with VFP's ODBC driver
  Alejandro A Sosa
  All
  Jan 30, 2021 @ 01:11pm

We are trying to create Power BI dashboards for our app's data.

Power BI can get data by importing the tables or by DirectQuery using an ODBC driver. We want to use DirectQuery, and also to provide the data through a web site.

To accomplish this, we would like to use the VFP ODBC driver, harvest the SELECT statement received by it, send it to the web site and feed the response back to the ODBC driver so it responds to Power BI.

Any ideas on how to accomplish this "trick"? Wish we had the source code to VFP ODBC driver!

TIA,

Alex

© 1996-2021