locked
Using Power Query with a FoxPro database? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am just starting to explore the PowerBI suite of solutions for a work project I have just started.

    What I am keen to know from the outset is whether it is possible to use a Visual FoxPro database as a datasource for Power Query?

    Thanks

    Sunday, February 9, 2014 9:25 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    There are currently no plans to support this database.

    Thanks

    Zafar Abbas

    Thursday, February 13, 2014 7:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Most VFP files can be pulled in using the ODBC capability in Power query.   The only issue I've found is with auto incrementing fields we get a 'not a table" message.    This can be worked around in Excel using the data function and the OLE DB driver but I have not spent enough time on it to figure out how to use the OLE driver in Power query.  

    Saturday, April 25, 2015 12:23 AM