Forum Discussion
Modifying table in Excel connected to Power Platform
Hi gogiwine,
Thanks for sharing the screenshot, that makes it clear.
In Excel, when we connect to a Power BI dataset it works as a live connection. Because of that, the Edit Query option doesn’t open Power Query like it normally does, so you are not able to click it this is expected.
If you need to bring in new columns, there are only two ways:
-
Go to the connection properties and update the Command Text the DAX query you see there to include the new column.
-
Or, the simpler way is to go to Get Data > From Power Bi Data set again and insert the table freshly with the extra fields selected.
So basically, in this type of connection you cannot open Power Query, you will have to either change the command text or re-insert the table.
Hope this clears it up.
Regards,
Community Support Team.-
Thank you. However, I can't click "Edit Query". (see below)
Did I do something wrong when inserting the table? Or do I need to update "command text"?
(not sure about security, so just hide the random characters in connection string)
Hi gogiwine,
Thanks for sharing the screenshot, that makes it clear.
In Excel, when we connect to a Power BI dataset it works as a live connection. Because of that, the Edit Query option doesn’t open Power Query like it normally does, so you are not able to click it this is expected.
If you need to bring in new columns, there are only two ways:
-
Go to the connection properties and update the Command Text the DAX query you see there to include the new column.
-
Or, the simpler way is to go to Get Data > From Power Bi Data set again and insert the table freshly with the extra fields selected.
So basically, in this type of connection you cannot open Power Query, you will have to either change the command text or re-insert the table.
Hope this clears it up.
Regards,
Community Support Team.