Power BI DBF file extension ODBC

[akwang]

Hi All,

So i was following this example from https://blogs.msdn.microsoft.com/samlester/2018/02/23/importing-a-dbf-file-into-power-bi/

since i have a DBF database i want to import and am getting this error message.

DataSource.Error: OLE DB: Could not find installable ISAM.
Details:
    DataSourceKind=OleDb
    DataSourcePath=data source="C:\Users\akwang\Desktop\RMA File\";extended properties='dBASE IV", [Query="select * from [RMA.DBF]';provider=Microsoft.ACE.OLEDB.12.0
    Message=Could not find installable ISAM.
    ErrorCode=-2147467259

Any Idea how to solve? i have a 64bit install of office.

[v-shex-msft]

HI @akwang,

It seems like you're use multiple extended properties in you connection string, right?
If this is a case, extended properties value tokens must be quoted.

Reference:

System.Data.OleDb.OleDbException: Could not find installable ISAM

If you use more than 1 extended property then the value tokens must be quoted, otherwise there is no way for the driver to distinguish them from the other non-extended properties in the connection string.

Regards,

Xiaoxin Sheng

[akwang]

Hi @v-shex-msft,

my code is:

= let
    Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12;Data Source=C:\Users\akwang\Desktop\RMA File\;Extended Properties=dBASE IV"", [Query=""select * from [rain.dbf]")
 in
    Source

This is exactly as stated in the blog. I followed the link you posted and tried different mods to the string such as

Extended Properties=dBASE IV;HDR=Yes""

Extended Properties='dBASE IV;HDR=Yes'"

And i get syntax ERROR.

[Anonymous]

Is that possible that PowerBI doesn't load a dbf file if the name of this dbf used capitalized letters and "_" ?

How can we load a dbf file if it takes this type of name ?

[gustavoleo]

The performance is terible and very unstable. The best way is using ODBC 64-bits driver like this go.helpbi.com/dbf

[v-shex-msft]

HI @akwang,

It seems like your issue is not caused with extended properties, maybe you can take a look at following official document to fix registry of dBase.

You receive a "Could not find installable ISAM" error message or some file types are missing when yo...

If above not help, you can also try to contact to author for know more about that operations.

Notice: please do backup before operate if you want to modify registry.  

Regards,

Xiaoxin Sheng