Forum Discussion
DataFormatError Unspecified Error refreshing access database table
I don't know why this happens, but I get the following when trying to refresh power query (in Excel) load: Any assistance would be appreciated!
It means Access OLEDB connector is fine. Restart your computer. Sometimes, simple restart of computer solves many problem.
If computer restart doesn't solve the issue (and when you can afford some break in work) - Try repairing your office installation. First try quick repair (typically takes 5-10 mins), if that doesn't solve the problem, try full repair ((typically takes 20-30 mins)
Thanks for the prompt reply Vijay. I have checked and both Access and Power BI are 64 bit.
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalCan you do a small experiment? Can you try this through Power BI Desktop and then see what message do you get?
I have no problem when using Power BI Desktop, only when using Power Query in Excel.