Forum Discussion
Live Connection
I recommend you just create a new connection. You can update the new columns, but you have to write a DAX query to do so.
If you go to the Data ribbon, click Queries and Connections and make sure the table in Excel is selected. Just one cell is enough.
- Right-click on the connection. It will start with pbiazure://api.powerbi.....
- Select Properties
- Click the Definition tab
- In the Command Text box is a DAX query. If you know how to write them, and what the new field names are, then update it.
What you could also try is create a new connection, then per above get the query from your new connection. Then paste it in your old connection. That would prevent you having to start over.
I recommend you just create a new connection. You can update the new columns, but you have to write a DAX query to do so.
If you go to the Data ribbon, click Queries and Connections and make sure the table in Excel is selected. Just one cell is enough.
- Right-click on the connection. It will start with pbiazure://api.powerbi.....
- Select Properties
- Click the Definition tab
- In the Command Text box is a DAX query. If you know how to write them, and what the new field names are, then update it.
What you could also try is create a new connection, then per above get the query from your new connection. Then paste it in your old connection. That would prevent you having to start over.