Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Connection to a Visual FoxPro Database

Hi everyone,   I'm new in the Power Bi universe, I'm working with this software since 2 months, so I don't have a lot of experience. I need to access a Visual FoxPro database in Power BI. Firstl...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Firstly, have you ever tried Visual FoxPro ODBC Driver?

 

Are the "Microsoft.ACE.OLEDB.12.0" Driver, Power BI Desktop, on-premises gateway installed on the same server as Visual FoxPro database ?

Based on my experience, on-premises gateway should be installed in the same server as the data source ( Visual FoxPro database in your scenario).

 

How do you add data source under the gateway?

Did you select Data source type=ODBC, use the correct connection string and authetication?

Here are some articles you could learn:

Enterprise Gateway with ODBC

Connect to data using generic interfaces in Power BI Desktop

 

Finally, if suggestions above can't slove the problem, please share the error message when gateway not working as expected and some other information as i mentioned.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.