Forum Discussion

megavic's avatar
megavic
Advocate II
9 years ago
Solved

Error refreshing Access database data tables on a network in PowerBI desktop

Hi,   I'm having an issue when refreshing queries from an Access database on the network. This was previously working OK, but currently when refreshing I get the error:  "DataFormat.Error: Could ...
Need Help
  • megavic's avatar
    megavic
    9 years ago

    Hi Qiuyun,

    Thanks for your help, yes the access DB is on a shared network with the filepath layout as per your comment.

    The four tables are all from the same database with one way relationships.

    Updated to the latest version and this is still an issue.

    I have band aided the issue by unticking 'Enable parallel loading of tables' in Options --> Current File, Data Load.

    Obviously this makes the query refresh take slightly longer but removes the annoyance of individually refreshing tables.

    I think I'll go with this for now as work is hectic at the moment.

    Again, thanks for you help :-)

megavic's avatar
megavic
Advocate II
9 years ago

Hi Qiuyun,

Thanks for your help, yes the access DB is on a shared network with the filepath layout as per your comment.

The four tables are all from the same database with one way relationships.

Updated to the latest version and this is still an issue.

I have band aided the issue by unticking 'Enable parallel loading of tables' in Options --> Current File, Data Load.

Obviously this makes the query refresh take slightly longer but removes the annoyance of individually refreshing tables.

I think I'll go with this for now as work is hectic at the moment.

Again, thanks for you help :-)

BillR's avatar
BillR
Frequent Visitor
9 years ago

Worked for me. Glad you found it.