I’ve be dabbling with Power BI Desktop to build a dashboard for a client and thought I’d share just how easy it is to connect an unencrypted Access database to Power BI Desktop to be able to produce some truly nice charts.
I emphasize Unencrypted, so no password on the database, as Microsoft has made it more complicated to connect to encrypted Access databases (that will be covered in my next post).