Live Connection

[Lisa_jaquezquez]

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!

[Lisa_jaquezquez]

@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

[edhans · Accepted solution]

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. 

1. Right-click on the connection. It will start with pbiazure://api.powerbi.....
2. Select Properties
3. Click the Definition tab
4. 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.