Forum Discussion

ashshiv_123's avatar
ashshiv_123
Icon for Helper I rankHelper I
3 years ago

Unable to get data in power BI via database-access database-connect. below error msg displayed.

Please help in above issue.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ashshiv_123 ,

    If I understand correctly, it seems that you got the error message when you tried to connect Access in Power BI Desktop. Am I right? First, please install the client software(Northwind.accdb) which refer in the error message popup.  Then make sure you have installed the Access Database Engine. And the bit version of Access Database Engine should match your Power BI Desktop version. You can refer the following links to make troubleshooting and try to solve the problem.

    Troubleshoot Access and XLS import issues in Power BI Desktop - Power BI | Microsoft Learn

    Fix Power Bi error microsoft.ace.oledb.12.0 with these solutions (windowsreport.com)

    Best Regards

  • hello Rena. yes, you understand correctly my issue. Thank you for providing solution. Due to certain limitations and policies at our end, we could not apply this solution. sorry for that. As i have not applied above solution to my problem, i do not know whether it is correct or not. If in future i am able apply, i will definitely let you know. Once again thank you for solution and sorry for not able to apply.

     

    Regards,

     

    Ashshiv_123

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi ashshiv_123 ,

      Thanks for your feedback. Looking forward to your update. Thank you.

      Best Regards