Forum Discussion
linked entity refresh logic different fro powerplatform dataflow connector v powerbi ddf connector
Hi, I think most people will be aware now that there are two DF connectors in PBI desktop. The advice seems to be move over to using the "Dataflows" connector rather than the "Power BI dataflows" connector. Sounds good, have done that.
However inside of dataflows there is the concept of linked entities where you connect from one dataflow to another. In the service there is also a choice of the two different connectors.
I've noticed taht there is different behaviour when using the "Dataflows" connector. For instance typically for a linked entity - there is no concept of incremental refresh. The UX even hides this option. When you refresh the source entity if the linked entity is in the same workspace, the linked entity also refreshes. However if you use the other connector- its different. You seemingly can set incremental refresh options AND the linked-entity-auto-refresh-logic-in-same-workspace no longer works.
Any ideas ?
10 Replies
- AnonymousNot applicable
Hi frano72 ,
When data refresh occurs for a source dataflow, that event automatically triggers a refresh process for dependent entities in all destination dataflows in the same workspace, including any calculated entities based on them. All other entities in the destination dataflow are refreshed according to the dataflow schedule. Entities that depend on more than one source refresh their data whenever any of their sources are refreshed successfully.
Hope this article can explain your doubts:
Link entities between dataflows
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- frano72Helper IV
Anonymous - hi - any feedback
- RobertSlatteryResponsive Resident
No, it does not. Unless you use the old Power BI connector. If you use the new Power Platform connector, at least for me (with "new" workspace) it does not link.
- frano72Helper IV
RobertSlattery - its weird hey. Found nothing on interwebs about it. I've instructed team to use the "new" dataflow connector from power bi desktop and the "old" dataflow connector inside of dataflows.
- frano72Helper IV
Hi Anonymous - that is certainly true if you use the "Power BI Dataflows" connector available in Power Query online. However, as I explained above - if you use the "Dataflows" connector - the auto refreshing is not working. There are other differences too as explained above. Try it out for yourself. I've included an image below of the two dataflow connectors that allow you to link to another entity.
- frano72Helper IV
Anonymous - Hi - any further feedback on my response ?
- DanalberAdvocate II
Hi, seems there is still no update on this. The linked flow with PowerPlatform connector does not automatically refresh if the source flow refreshes. 😞 It is not even mentioned in the documentation.
So for linked flows we still have to use the PowerBI (legacy) connector.
Hope they fix this soon.
BR
-> Update: I just realised, the refresh link only works if the referenced table is set to "enable load". If this is not activated the automatic refresh via the link to the source flow is not working.