.DBF files as Data source

[irrefutable14]

I have a folder of .dbf files  stored on a network folder that I want to have as a custom data set.

I've researhed around and cant seem to find out how to make this work. I'd like to have it

pull from this folder as things will be exported to that folder daily. Any ideas?

[YagoAndrade]

Boa tarde, aqui eu fiz e funcionou perfeitamente. Só estou com uma dúvida.. Nesse caso os meus registros cancelados do DBF eu não consigo visualizar dentro do power BI. Como fazer para visualizar tanto os registros ativos quanto os cancelados?

[v-ljerr-msft · Accepted solution]

Hi @irrefutable14,

Here is a similar thread in which a solution is mentioned. Could you go to check if it works in your scenario? 

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.

---

Regards