topic Re: .DBF files as Data source in Developer

.DBF files as Data source

irrefutable14 — Thu, 01 Feb 2018 15:39:52 GMT

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?

Re: .DBF files as Data source

v-ljerr-msft — Fri, 02 Feb 2018 06:52:38 GMT

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

Re: .DBF files as Data source

YagoAndrade — Thu, 22 Sep 2022 18:13:28 GMT

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?