Skip to main content

Power BI

Needs Votes

dbf

Vote (249) Share
Power BI User's profile image

Power BI User on 09 Mar 2015 02:51:32

Comments (71)
Power BI User's profile image Profile Picture

d70c3209 d165-4022-8aaf-86dd6b365170 on 06 Jul 2020 00:18:25

RE: dbf

please native dbf access to be provided

Power BI User's profile image Profile Picture

57fead52 1ca2-4837-9ab7-cc309fc4e002 on 06 Jul 2020 00:17:25

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

Power BI User's profile image Profile Picture

bc7f07ed d556-4467-97dc-34cf3d9529c9 on 06 Jul 2020 00:12:50

RE: dbf

it would be helpful to be able to import DBF!

Power BI User's profile image Profile Picture

8ced3601 63a6-4499-8a2c-6e198c4f2125 on 06 Jul 2020 00:09:27

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.

Power BI User's profile image Profile Picture

ef706472 bbac-438c-93a9-ce672727c559 on 06 Jul 2020 00:09:21

RE: dbf

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

Power BI User's profile image Profile Picture

42010091 de40-4344-80f7-55f187d204f7 on 06 Jul 2020 00:03:46

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.

Power BI User's profile image Profile Picture

d6ff1380 1560-47c8-92e9-187b8a31e7fa on 06 Jul 2020 00:01:19

RE: dbf

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

Power BI User's profile image Profile Picture

8355bf3b 9b2f-470d-9101-9621f016dac1 on 06 Jul 2020 00:01:16

RE: dbf

It would be great to have a possibility to import data from dbf files

Power BI User's profile image Profile Picture

74bf7dc3 183c-4300-bc7e-a9fa0ab32c6f on 05 Jul 2020 23:59:52

RE: dbf

let
Source = OleDb.DataSource("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Blog\DBF\;extended properties=dBASE IV", [Query="select * from [rain.dbf]"])
in
Source

Power BI User's profile image Profile Picture

f6d15204 c835-4a08-9c7a-0b4223ed147c on 05 Jul 2020 23:59:18

RE: dbf

please add possibility to import data from dbf files