LinkBack URL
About LinkBacks
Hi Experts,
as I mention in title I have a problem with adding to power query a dbf file with over 1M rows. What kind of data source I need to choose or to what format I need to convert dbf to load to PQ ?
Thanks for help !
Hi Experts,
as I mention in title I have a problem with adding to power query a dbf file with over 1M rows. What kind of data source I need to choose or to what format I need to convert dbf to load to PQ ?
Thanks for help !
Try:
Change the path to match your dbf location.
Please Login or Register to view this content.
Last edited by Olly; 07-26-2017 at 06:16 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I receive this kind of errorPlease Login or Register to view this content.
The Microsoft ODBC Desktop Database drivers include dBase drivers. Make sure you have dBase set up as a DSN source (Control Panel > Administrative Tools > Set Up Data Sources (ODBC) )
This is what I have.
When you go to Data tab -> New Query, choose From Other Sources -> From ODBC
There you should see option to choose DSN. If you don't see dBASE files there, check following link.
https://support.microsoft.com/en-us/...on-64-bit-vers
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
I have office 32 bit, windows 7 64 bit and after instalation of this drivers https://www.microsoft.com/en-us/down....aspx?id=40886 in 32 bit version I still see the same error.
Try this one: https://www.microsoft.com/en-us/down....aspx?id=13255
Still same error
It's the ACEODBC.DLL which contains the necessary dBase driver:
odbc_dsn_dbase.jpg
odbc_dsn_dbase_new.jpg
If you're using Office 2013 32-bit, then you'll need the 32-bit drivers installed, using my link in post #8.
Also, you may need to install 2007 Office System Driver: Data Connectivity Components
You will find this specific issue detailed in the link I provided earlier.
Also see links below.
https://support.microsoft.com/en-ca/...-64-bit-user-d
https://social.technet.microsoft.com...itproappcompat
I instaled 32 bit drivers and added it to SysWOW64 --> odbcad32 (they also appeared to System32 --> odbcad32 in DSN Users) but they are not avaiable from Create New Data Source in System32 --> odbcad32. Do you have an idea how to change it ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks