cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gkim Frequent Visitor
Frequent 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 Frequent Visitor
Frequent 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 Frequent Visitor
Frequent 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 Frequent Visitor
Frequent 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

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 Frequent Visitor
Frequent 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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors