Pulling in .dbf files

[vanessafvg]

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

[jpretorius]

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

[v-yuezhe-msft]

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

[gustavoleo]

The easyest way is using this driver (ODBC and 64-bits) go.helpbi.com/dbf