PowerBI Web + Azure SQL Database

[lfaltran]

Hi,

I'm new on PowerBi (comming from Qlik Cloud) and configuring my environment for rich BI analysis. All my services are hosted on MS Azure Cloud (application, database, DNS and more), my application (Java + JSF) use embed feature to display BI analysis direct on my app.

Now, I'm looking to improve refresh rate of data on my report, everything is pointing to use PowerBI desktop to refresh my data, but it is not so flexible on my architeture.

There is any other way to achieve this?

Thank you

[v-qiuyu-msft · Accepted solution]

Hi @lfaltran,

Did you use the Power BI embedded feature to embed report in a web application? If so, it supports Azure SQL database in DirectQuery mode. When you interact the visual in report or refresh the page, the data will get updated. See: Connect to a data source.

Best Regards,
Qiuyun Yu