Creating a live dashboard using SQL data

[Anonymous]

Hello,

Can someone please direct me to a link/resource where I can understand how I can prepare a live report (which refreshes whenever there's a change in the data) in Power BI? 

My data is sitting in SQL tables and my ultimate goal is to get the report embedded into a website. (Given that I have access to a premium account). 

Thanks in advance

[v-yetao1-msft · Accepted solution]

Hi @Anonymous 

“embedded into a website” means publish the report to Service and then users can access the report in Power BI Service ? If you want to refresh whenever there's a change in the data in Power BI Service, you need to configure a standard gateway so that you can refresh your data at any time .

Install and configure standard gateway can refer to the link below .

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app

Manage your SQL datasource in Manage gateways in Service can refer to this link .

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql

Configure scheduled refresh can refer to this link.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@amitchandak Hello Amit,

Thanks for reaching out!

The SQL database is not very optimized and I usually fetch data using customized stored procedures as the data is quite dynamic in nature. Given that direct query doesn't allow us to run stored procedures, is there any workaround for that?

Thanks in advance

[amitchandak]

@Anonymous , You can create a report a direct query data model

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

There is an option auto-detect to refresh page option - https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh