Power BI User on 09 Mar 2015 02:51:32
- Comments (74)
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 usingOdbc.DataSourceOdbc.QueryOleDb.DataSourceOleDb.QueryIt requires that the DBF file exist in the local file system. Should the DBF file exist:in a Zip archiveon the WebThe 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