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