dbf

RE: dbf

While I note there are a few solution to importing DBF files into PowerQuery, there is a fundamental problem with the DSN type approach using

• Odbc.DataSource
• Odbc.Query
• OleDb.DataSource
• OleDb.Query

It requires that the DBF file exist in the local file system. Should the DBF file exist:

• in a Zip archive
• on the Web

The DSN approach breaks down since the existing Odbc.* and OleDb.* function do not permit binary contents to be specified.

For example:

dbfBinary = Web.Contents( "https://example.org/my.dbf" )

None of the Odbc.* or OleDB.* functions can be used to produce a table from a binary DBF. PowerQuery really needs something like:

dbfBinary = Web.Contents( "https://example.org/my.dbf" ),

dbfTable = Dbf.Contents( dbfBinary )

this could also work for the local file system or even extracting the DBF from a Zip archive:

dbfOptions = [ ],

dbfBinary1 = File.Contents( "C:\my.dbf" ),

dbfTable1 = Dbf.Contents( dbfBinary1, dbfOptions ),

zipBinary = File.Contents( "C:\my.zip" ),

zipTable = ZipArchiveDirectory( zipBinary ),

dbfBinary2 = ZipArchiveContents( zipTable, "my.dbf" ),

dbfTable2 = Dbf.Contents( dbfBinary2, dbfOptions )

Please add a Dbf.Contents function to PowerQuery to allow these additional use cases.

RE: dbf

Definitely - SAP allows export via dbf file so would make it easy to pick up in PBI.

RE: dbf

weird that we need to vote to get dbf opened. This should be basic !!!

RE: dbf

please native dbf access to be provided

RE: dbf

Yes, Please provide a way to load .dbf files. Certain geospatial databases are still being written in dBase. There are also many companies using dbase.
Thank you

RE: dbf

it would be helpful to be able to import DBF!

RE: dbf

Hi Niket Shaju, could you please explain how you are doing it? I am able to import dbf files with the FoxPro OLE DB provider and the 32 bit version of Power BI Desktop as suggested by Giuliano below, but this solution does not work with the gateway for scheduled refresh.

RE: dbf

Looks like this worked. We are able to upload dbf databases onto PowerBI now

RE: dbf

A = Power BI (Microsoft)
B = Visual Foxpro (Microsoft(

A+B = 0??

Almost all the data from our company is in DBF or Excel files.

RE: dbf

The fast and best way uis using an ODBC and 64-bits driver like this go.helpbi.com/dbf