Forum Discussion
sbatool
Helper I
Helper IDataflow - linked entities in the same workspace - refresh not working automatically
Hi, We have 3 dataflow entities in the same workspace, say: Entity1 contains history data Entity2 contains live data Entity3 uses Entity1 and Entity2 as linked entities to append them together (...
Hi sbatool,
recording to the documentation I believe it should work indeed.
But there are some Limitations and considerations:
- There is a maximum of five referencing hops
- Cyclic dependencies of linked entities are not allowed
- The dataflow must reside in a new Power BI workspace
- A linked entity can't be joined with a regular entity that gets its data from an on-premises data source
- When a query (query A, for example) is used in the calculation of another query (query B) in dataflows, query B becomes a calculated entity. Calculated entities cannot refer to on-premises sources.
Are any of those matching your case?
nickyvv
Most Valuable Professional
Most Valuable ProfessionalHi sbatool,
recording to the documentation I believe it should work indeed.
But there are some Limitations and considerations:
- There is a maximum of five referencing hops
- Cyclic dependencies of linked entities are not allowed
- The dataflow must reside in a new Power BI workspace
- A linked entity can't be joined with a regular entity that gets its data from an on-premises data source
- When a query (query A, for example) is used in the calculation of another query (query B) in dataflows, query B becomes a calculated entity. Calculated entities cannot refer to on-premises sources.
Are any of those matching your case?
