Forum Discussion
Dataflows - Only Refresh Specific Tables
Hi Anonymous
Linked Entities refresh differently if they are together in the workspace or in separate workspaces. If all together in the same workspace, refreshing the main Dataflow will also force the linked entities to refresh. If the linked entities are in other workspaces, refreshing the dataflow will not force a refresh in the linked entities. Be aware that Linked Entities require a Premium licence. In this case I'd just go with two separate Dataflows, not linked, with different refresh schedules. Simpler, cheaper and gets the job done.
Hope this helps
Stuart
thanks Stuart, I thought about that however if I add dimension data flow as a linked entity to Fact data flow, do you know how set up refresh in fact data flow works? Does it also refreshes linked entity?
Hi Anonymous
Linked Entities refresh differently if they are together in the workspace or in separate workspaces. If all together in the same workspace, refreshing the main Dataflow will also force the linked entities to refresh. If the linked entities are in other workspaces, refreshing the dataflow will not force a refresh in the linked entities. Be aware that Linked Entities require a Premium licence. In this case I'd just go with two separate Dataflows, not linked, with different refresh schedules. Simpler, cheaper and gets the job done.
Hope this helps
Stuart
really helpful, thank you very much. one more question, when I want to use that data flow in Power BI desktop, I can only use one data flow right? that's why I brought two data flows together by using linked entities.
sorry, I just realised I can bring different entities from different data flows to Desktop. You can ignore my question above. thank you for your response.
Burningsuit In the dataflow that contains the linked entities from the same work space, is it just the linked entities that are refreshed, or is the entire dataflow refreshed?
For example, if I have one linked Employee table, will it only refresh the Employee linked entity (and any associated merged computed tables)? Or, will Employee and ALL the other dataflow tables refresh?
Is there a way to NOT have linked tables refresh when the source dataflow is running?
