Azure SQL is now available in Power BI Preview and it supports live connections to the database. The query connection is live back to the database and the tile refresh interval is 15 minutes (e.g. time to refresh your dashboard visualization).
Note that there are some limitations currently on the data refresh in general:
- Refresh is not supported for Power BI Designer files.
- If you’ve manually entered a SQL statement to execute, this cannot be scheduled for refresh. The alternative is to build the query by selecting the tables or views through the UI.
Once you have connected to your Azure SQL database, you can create standard Power PI Preview dashboards. Here is an example dashboard of the posts from this blog by year and by tag.