Load data automatically into chart

[hellgoingon]

Hi all,

I'm using Power BI desktop to load data (from SQL server 2012) into charts and publish chart to dashboard on website (https://app.powerbi.com/groups/me/dashboards/).

When data in SQL server 2012 is changed, how can these changes be updated automatically into charts?

[BhaveshPatel · Accepted solution]

Should use DirectQuery to connect to SQL Server.

[ankitpatira · Accepted solution]

@hellgoingon You have few options depending on how comfortable are you with the approach.

1. Use schedule refresh of power bi to periodically update data in visuals.

2. Use DirectQuery feature of power bi ie you connect live to your SQL database and don't require any refresh. Data in your visuals is live and always upto date.

3. User Power BI REST API to programatically push data in real-time to dataset that is published to power bi service.

[hellgoingon]

It works perfectly with DirectQuery. Thanks for help.

[BhaveshPatel · Accepted solution]

Should use DirectQuery to connect to SQL Server.