Why can't I edit a table built from a Power BI Semantic Model?

[goncalodfs96]

Hi,

I have built a table in Excel using the Get Data from Power Platform > Power BI Model Semantic Model. I have constructed it by selecting the fields I want to include.

Now, I want to edit it, for example, filter it and change a field. But the option "Edit query" is disabled. I can only edit it through the coding option:

Does anyone have the same problem? How can I enable the "Edit query" option? Is there any 'more friendly' option to edit the table?

Thank you! Cheers,

Gonçalo

[lbendlin · Accepted solution]

You modify the DAX query in the command text.

For a 'more friendly' option you can use DAX Studio's Query Builder, and then copy the resulting DAX from there.

[Anonymous · Accepted solution]

Hi @goncalodfs96 

In Excel, connecting to the Power BI semantic model is Live connection mode, and Power Query is not supported in Live connection mode. Please refer to this similar case: Solved: How to load a PowerBI symantic model as source for... - Microsoft Fabric Community

Like Ibendlin said, you can edit the DAX queries in "Commond text".

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

You modify the DAX query in the command text.

For a 'more friendly' option you can use DAX Studio's Query Builder, and then copy the resulting DAX from there.