Update Power BI after importing data model?

[macfuller]

I have a desktop PowerBI file created from a PowerPivot model using File | Import. I updated the source Excel file with a new table using PowerQuery and I would like that table to also appear in the PowerBI file. I can't figure out how to do that. If I try File | Import again it blows away my existing work, and if I try Get Data | Excel it only shows me worksheets and not data model tables.

Is there a way to get the new data model table into Power BI without having to reconstruct the whole thing?

 

[ParamRay]

I believe after the import, the data model in Power BI does not maintain a link to the original data model in Excel.

However, you can copy the query text from Power Query in Excel (via the Advanced Editor button) and paste it into the same dialog in Power BI.

 

[macfuller]

Thanks, that did the trick with a bit of tweaking to point it to the full file path name.

The .pbix file does refresh against the spreadsheet, but apparently just against the queries it originally imported. I haven't tested whether, if I change the query in the spreadsheet, the PowerBI refresh will read the altered query...