I have a table in power bi which has calculated column based on azure table and Dataverse. (Dataverse is used for write back feature using power automate as few of the column value get changed). Table in power bi which has value from azure and new calculated columns need to be snapshot once in a month, as power bi does not have partial refresh feature and we need to maintain those historical record. current implementation: I did with dataflow by appending that dataflow table in powerbi dataset (i have only access to gen1 don't have rights for gen2) however it only store one past record as once the dataflow gets refreshed it also does not have history. how to do it with data flow or with any other work around.
