cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gkim
Regular Visitor

OLE DB or ODBC error: [DataFormat.Error] Unspecified error

I've been importing a table from Access DB into Power BI on a weekly basis and appending it to the master table for Power BI.

Every time I do apply changes, an error below occurs.

OLE DB or ODBC error: [DataFormat.Error] Unspecified error

I am not sure what causes it.. can anyone help please?

8 REPLIES 8
Super User II
Super User II

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

gkim
Regular Visitor

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

I really appreciate your reply.

But I already deleted 32-bit Access and now have 64-bit for both Access and Power BI installed.

Do you know any other possible reasons causing this issue?

Super User II
Super User II

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

Hi @gkim,

what I always try if something similar happens: Create a new pbix file, clear Data Cache (File/Options/Global/Data Load/Clear Cache), load the data again.

It eliminates a lot of posible problems.

gkim
Regular Visitor

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

It looked it was working at the beginning, but ended up with the same error....

Could you please help find any other solutions?

If I keep trying applying changes after a few error messages come up, it works eventually.

but it's very time-consuming... Also, it's going to take more time as I append a new data every week.

gkim
Regular Visitor

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

@Nolock Could you please help me out? I'm still getting the same error when I add and refreash data

Highlighted
Super User II
Super User II

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

Hi @gkim,

Access is a database system which allows some concurrent users. But maybe it could be a source of troubles. Do you have an exclusive access to the Access DB file at the time of reading it or is the database unter load?

gkim
Regular Visitor

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

@Nolock Yes, I'm the only one managing the database. I tried to google the same issue to find possible solutions, but couldn't really find one.. What's your recommendation?

Super User II
Super User II

Re: OLE DB or ODBC error: [DataFormat.Error] Unspecified error

Hi @gkim,

I'm very sorry, I don't have any ideas more.

It is weird that it sometimes works and sometimes doesn't. That's worse that when it doesn't work at all.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors