how to connect database in power bi code example

Example: add mysql database to power bi web

No, your best bet is to build an Analysis Services Tabular model on top of it and 
have it processed reasonably often enough to have real time dashboards for your users.