cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
frano72
Helper IV
Helper IV

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 ?

9 REPLIES 9
frano72
Helper IV
Helper IV

@v-caitlyn-mstf  - Hi - any further feedback on my response ?

frano72
Helper IV
Helper IV

Hi @v-caitlyn-mstf  - 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.

 

 

2022-01-25_19-32-10.jpg

Hi @v-caitlyn-mstf - any further feedback ?

Hi @frano72 ,

 

Sorry, based on my current knowledge, I am unable to help you better on this issue and look forward to having an expert in this area to answer your questions.

 

Community Support Team _ Caitlyn

v-caitlyn-mstf
Community Support
Community Support

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 _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

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.

@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.

Yes, shifty as...

At least I'm not the only one, I am doing exactly as you and using the both conectors depending on the application.

@v-caitlyn-mstf - hi - any feedback 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Top Solution Authors
Top Kudoed Authors