July 20, 2015 at 5:14 am
Hi,
Currently i have set of queries which i run for data extraction and result pasted in Excel table so that my pivot table and Chart gets populated along with the summary in Excel file.
I would like to automate this thing and want to know if i can achieve excel output for dashboard on a click of button.
Please help.
July 20, 2015 at 6:02 am
bhaskar.thapa (7/20/2015)
Hi,Currently i have set of queries which i run for data extraction and result pasted in Excel table so that my pivot table and Chart gets populated along with the summary in Excel file.
I would like to automate this thing and want to know if i can achieve excel output for dashboard on a click of button.
Please help.
Quick suggestion, use PowerQuery to feed straight into a PowerPivot and model your graphs and pivot tables from there.
😎
August 24, 2015 at 7:48 am
have used a coupe of techniques for this:
1. VBA in Excel including a refresh parameter which polls database for results
2. SQL Server Reporting Services which has a refresh parameter built in - a little more work to configure ReportServer and ReportManager though
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply