Accessing data in Visual FoxPro database from 64 bit Power BI?

[jimr84]

I have a report that pulls data from a Visual FoxPro database. It works perfectly fine using 32 bit Power BI, but I'm trying to publish this to the web and have an on-premise gateway keep the data updated. The problem that I'm encountering is that the gateway is only available as a 64 bit application, which won't talk to the 32 bit VFP driver. There is no 64 bit Visual FoxPro driver available.

I've tried searching for solutions but I'm struggling to find anything that actually works. Does anyone have any suggestions?

[v-jianboli-msft]

Hi @jimr84 ,

Please find and install the odbc driver for 64-bit. Here are several links about this, hope these could give you some help:

System Requirements (Visual FoxPro ODBC Driver)

Visual FoxPro Downloads

If that could not work, here is a workaround:

Use 32-bit compatible PowerBI Desktop to connect to a data source and publish it to Power BI Service. When you want to refresh the data, download the PBIX file, refresh the data again through Desktop and republish.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jimr84]

Thanks for the reply! I'm able to publish this with a 32-bit version of PBI Desktop without issue. Unfortunately, I was hoping to have the data refreshed at least a couple times a day without me having to manually do it. I checked the links for the 64-bit ODBC driver, but everything I'm seeing is 32-bit?