Resolving Connection Issues from Power BI to MS Access Password Protected Database

Опубликовано: 29 Сентябрь 2024
на канале: YouVolve
606
6

If you are planning to build your career as a data engineer, analyst, data scientist or a reporting expert, one of the best things to do is to learn Microsoft Power BI. In this tutorial I am going to demonstrate how to connect Power BI with both a Password Protected and an Unprotected Microsoft Access Database and resolve any connection issues.

While connecting to an unprotected access DB is quite simple, I have seen quite a few issues are encountered by Power BI users when connecting to a password protected MS Access databases because there is no straight forward method to connect to a password protected access database.

I made this video which will be helpful in resolving these connection issue. I have separate tutorials on how to download and install Power BI to create informative, nice looking analytical reports from different database like Oracle, MySQL, Postgres or even MS Access etc. You may watch the tutorials using the links below:

Watch the full video on how to create a simple analytical report with

Power BI and Oracle:
   • How to Connect Microsoft Power BI to ...  
   • How To Create An Analytical Report In...  

Power BI and MySQL:
   • How To Create An Analytical Report In...  
   • Step by Step - Create a Simple Tabula...  

Power BI and MS SQL Server:    • How To Create An Analytical Report In...  
Power BI and MS Excel Spreadsheet:    • Pull Excel Data into Power BI - Creat...  
Power BI and PostgreSQL:    • Create a Simple Analytical Report in ...