Forum Discussion
vanessafvg
10 years agoCommunity Champion
Pulling in .dbf files
I can't figure how to pull in a .dbf file- i know its a database file (so is not on a server), how does one access the data from the file in Power BI
Anonymous
10 years agoNot applicable
Hi vanessafvg,
As far as I know, we are not able to connect to .dbf file from Power BI Desktop. Regarding to this issue, please vote it in this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7185167-dbf .
In addition, to work around this issue, you can firstly use Microsoft Access or Microsoft Excel to import the data from .dbf files into an Access database or Excel spreadsheets, then use Power BI Desktop to connect to Access database or Excel file.
Thanks,
Lydia Zhang
gustavoleo
6 years agoAdvocate II
The easyest way is using this driver (ODBC and 64-bits) go.helpbi.com/dbf