Forum Discussion

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity 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
jpretorius's avatar
jpretorius
Icon for Advocate I rankAdvocate 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