Forum

Edit Power Query Ta...
 
Notifications
Clear all

Edit Power Query Table by user in workbook

3 Posts
2 Users
0 Reactions
171 Views
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hi Guys,

i have table from Power query but i want to allow user to edit data and save the result directly from workbook table.

so create power query, output to worksheet, add to user to modified, allow user to edit data and save data + possibility to reset to default state. 

Please help,

Best,
Jacek

 
Posted : 19/06/2021 4:14 am
(@catalinb)
Posts: 1937
Member Admin
 

The result of the query is editable, users can do whatever they want with the results of the query.

If they want to reset, all they need to do is to refresh that query. All you mentioned can already be done, so not following what you mean.

 
Posted : 23/06/2021 12:34 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Thank you Catalin,

i figured it out. 
User is editing table and just using Workbook [Content] table method i can import all customizations done by user. 
And compare 🙂 

Best,
Jacek

 
Posted : 23/06/2021 2:32 am
Share: