Forum Discussion
Live Connection
Hello - I have a live connection set up in excel from a power bi report on our PBI Service. I have discovered more columns were added to to the PBI report - my live connection is not pulling in the new columns. Refreshing does not bring them in. How do I update the live connection to include the new columns?
Also, how do I 'grab' live connection data without having to rebuild an excel workbook. Currently the only way I can I know is to export rather than import.
Thank you!
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.
2 Replies
edhans - THANK YOU! Your second suggestion was what finally worked. I copied and pasted the DAX from a new connection. I am happy to know I was on the right track with adding the column in the DAX, but is just did not work. I REALLY appreaciate your help!
Lisa
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.
