Best Way?

Occasional Visitor



I am creating a workbook which will live in SharePoint and will be used as a register to hold sales data etc. 


I need to create a couple of additional workbooks which will be dashboards to show some data and reports from the main register, these will be local files for people to keep on their laptops. These are all based on pivot tables from the main register.


What would be the best way to create the connection between the dashboard and the register? I've looked at data connections, or just selecting the range in the register when creating the pivot, which would be best? If the data connection, I would appreciate some help in creating the connection if possible as I'm not sure about how to do this with SharePoint.




1 Reply

IMHO, the best way is to connect and transform data using Power Query, add some measures in data model using Power Pivot and finally pivot into Excel dashboard. Even more better to publish dashboards on Power BI services.


However, that requires to invest some time in learning of above tools if you are not familiar with them.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies