Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
10 years ago

Pulling in .dbf files

I can't figure how to pull in a .dbf file- i know its a database file (so is not on a server), how does one access the data from the file in Power BI

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi vanessafvg,

    As far as I know, we are not able to connect to .dbf file from Power BI Desktop. Regarding to this issue, please vote it in this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7185167-dbf .

    In addition, to work around this issue, you can firstly use Microsoft Access or Microsoft Excel to import the data from .dbf files into an Access database or Excel spreadsheets, then use Power BI Desktop to connect to Access database or Excel file.


    Thanks,
    Lydia Zhang

  • jpretorius's avatar
    jpretorius
    Advocate I
    8 years ago

     

    You could try the below:

     

    let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<Path to folder containing dbf file>;extended properties=<dbase version>", [Query="select * from [<dbf file name>.<dbf file extension>]"])
in
    Source

     

    Example:

    let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\dbfFolder\;extended properties=dBASE IV", [Query="select * from [myFile.dbf]"])
in
    Source

     

    You'll need the Access Database Engine provider deployed.

     

    James