Forum Discussion

irrefutable14's avatar
irrefutable14
New Member
8 years ago
Solved

.DBF files as Data source

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?

 

 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi irrefutable14,

     

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

    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

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi irrefutable14,

     

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

    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

  • YagoAndrade's avatar
    YagoAndrade
    New Member
    3 years ago

    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?