Connected Tables edit query in UI

[NWDBA]

If you insert a connected table from a Power BI semantic model into excel you cannot edit the query in the UI. This functionality would benefit non technical users who do not know how to code in DAX. Currently when a user wants to add/remove a field in a connected table they need to insert an entire new table.

[vanthuan_nguyen]

I totally agree with you. @Microsoft Team: could you please add this feature quickly?

[Anonymous]

This would seem an obvious feature enhancement.

[3imad]

This is a very much needed feature. Currently it's impossible to work with pivot tables that use MDX translation full of CROSS joins that make both performance and capacity usage a big hurdle