Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Should use DirectQuery to connect to SQL Server.
@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 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.
It works perfectly with DirectQuery. Thanks for help.
Should use DirectQuery to connect to SQL Server.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |