Forum Discussion

nbarze0511's avatar
nbarze0511
New Member
3 years ago

Refreshing Historical Records in Power BI Table

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?

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      nbarze0511
      New Member
      3 years ago

      It is not via a dataflow and reconnecting the dataset did not work. ğŸ¤”

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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's avatar
      nbarze0511
      New Member
      3 years ago

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