Refreshing Historical Records in Power BI Table

[nbarze0511]

We made some changes to our historical data, added information to a previously blank field. Our data set is from Dynamics 365. However, when I refresh the data set the new information is not updated in Power BI.

When we update information from other tables the information is updated. Not sure what the difference would be for the full table not to update. 

Is there a specific way to update historical data in Power BI tables?

[Greg_Deckler]

@nbarze0511 Are you using incremental refresh on that particular table?

[nbarze0511]

This is the only refresh set up for the whole data set:

[helpme]

Hi, is this connection to D365 via a dataflow? it might be that you need to refresh the dataflow first.

If not, try resetting the connection to D365 by clearing the permission setting and reconnecting the dataset.

[nbarze0511]

It is not via a dataflow and reconnecting the dataset did not work. 🤔

[v-cgao-msft]

Hi @nbarze0511 ,

Please right-click on this table in PowerQuery and check if Include in Report Refresh is checked.

If not, you need to check this option and then save and republish for it to take effect.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[nbarze0511]

It was already set this way.