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,
Having the following scenario: Windows 2012 + SQL Server 2016 Enterprise + Microsoft Power BI RS
A table name data with the fields (id, salesid, amount)
From End User side: Windows 10 + Power BI
The question: If I the table data is updated, how could I make that my dashboard be updated automatically with the new info with pressing refresh button? Is threre any step by step pdf, video, blog?
Thanks in advance.
Solved! Go to Solution.
@luiscontrerasdo,
Do your end user have Power BI Service account? If so, you can connect to SQL Server database in Power BI Desktop , create report in Power BI Desktop and publish the report to Power BI Service, there is an article for your reference..
Then you can install gateway on your server, add the SQL Server data source within gateway following the guide in this article, and set schedule refresh for your dataset in Power BI Service. After that, you can share the report to your end users.
However, if you need to set schedule refresh in Power BI Report Service, please review this article.
Regards,
Lydia
@luiscontrerasdo,
Do your end user have Power BI Service account? If so, you can connect to SQL Server database in Power BI Desktop , create report in Power BI Desktop and publish the report to Power BI Service, there is an article for your reference..
Then you can install gateway on your server, add the SQL Server data source within gateway following the guide in this article, and set schedule refresh for your dataset in Power BI Service. After that, you can share the report to your end users.
However, if you need to set schedule refresh in Power BI Report Service, please review this article.
Regards,
Lydia
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |