Enable Power Query editing for Power BI Semantic Model connections in Excel for changes

Currently, Excel allows connection to Power BI semantic models primarily through PivotTables. While limited editing is technically possible, it requires the use of DAX queries, which is not user-friendly for most business users.

Unlike SQL Server or other sources, there is no simple way to:

• Edit existing connections
• Filter columns or rows
• Shape data using Power Query

This creates a usability gap, especially for users who rely on Excel for flexible data preparation.