How to Update Additional Data Rowsfrom an Excel Data model Previously Imported into Power BI Desktop

[MikeMcGilvray]

Hi Folks

I have loaded an excel data model into PBI Desktop and started creating reports using this model.

The excel data Tables and Table Relationships and Measures have all loaded into PBI Desktop.

Excel Table ---> Excel Power Pivot Data Table  ---> PBI Desktop Data Table

I have since added additional data to the excel Tables (and this has updated in the Excel Power Pivot Data Table)

I cannot find a way to update the PBI data Tables with the additional data in the Excel data model.

The refresh option in PBI will only load the original number of rows of data.

I must be missing something obvious as this would seem to be basic functionality?

Pls help.

thanks

Mike

[Ritaf1983 · Accepted solution]

Hi @MikeMcGilvray 

If I understood you correctly the refresh is in the desktop (not at the service after publishing the report)
You need to refresh the report from the "front" side :

make sure that the Excel file is closed while refreshing.

Please refer to the linked tutorial

https://www.youtube.com/watch?v=gDA_BhyE1qw

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[MikeMcGilvray]

Hi, many thanks for your prompt reply.

Yes, I am trying to update the PBI desktop data.

I have tried following your suggestion (I had tried this many times before), but the refresh seems to be stuck and only loading the same number of rows that were in the excel data model when I first imported the file.

I looked at the link you sent, but it only seems to relate to excel data tables, and not to an excel data model (ie Power Pivot data tables with relationships and measures.)

I did see in some help notes that there is a flag setting where you can specify that you want the refresh to include new data that has been added to the excel file, rather than just updating the existing data, but I didn't get that option when I imported the excel data file first time.  Also I can't find an option to change this setting, if it exists at all?