AlexNYExcel
New Member
- Joined
- Jul 31, 2015
- Messages
- 11
Here it the thing.
I have workbook that connected to SharePoint lists and file and intended to end-user. Data flow from SP goes to hidden sheets (very hidden via VBA). Then kicks in some modeling and transformation and data loaded to Data Model (Pivot table) only clean and what allowed to see for end-user. But what worries me:
- if the user will try to create pivot table - it will show all tables that inside the workbook with data that not allowed for them to see!!!
For sure they could find it in Power Query as well, but this not worry me much as could be hidden inside function and they need to be pretty advanced to get there and find insights.
Any suggestions on how to disable Pivot Table options inside workbook or hide what could be seen in Pivot Table???
Other recommendations are welcome as well, for e.g. nothing worked for me to connect from PQ to SP, used Data tab - From Other Sources
I have workbook that connected to SharePoint lists and file and intended to end-user. Data flow from SP goes to hidden sheets (very hidden via VBA). Then kicks in some modeling and transformation and data loaded to Data Model (Pivot table) only clean and what allowed to see for end-user. But what worries me:
- if the user will try to create pivot table - it will show all tables that inside the workbook with data that not allowed for them to see!!!
For sure they could find it in Power Query as well, but this not worry me much as could be hidden inside function and they need to be pretty advanced to get there and find insights.
Any suggestions on how to disable Pivot Table options inside workbook or hide what could be seen in Pivot Table???
Other recommendations are welcome as well, for e.g. nothing worked for me to connect from PQ to SP, used Data tab - From Other Sources
