Forum Discussion
Table data is not populating when referenced in same dataflow or linked.
I have a dataflow A with two tables Table_1 and Table_2, the Table_1 data is ingested into this dataflow A from another workspace - The data is shown in this dataflow A. Table_2 is created in Dataflow A directly.
when I linked these two tables to another dataflow B in same workspace. The Table_1 and Table_2 data is populating, but When I reference Table_1 data and create a new table dimTable_1 without any mashup or steps inside, the data is not showing.
I checked this by extracting all these tables in PowerBI desktop.
Hi nikhil0511 ,
After linking or referencing tables between data streams, the source and target data streams need to be refreshed to ensure the latest data is available.
Linked tables require a Power BI Premium subscription to be refreshed. Linked tables can be used in any data flow within a workspace hosted on Power BI Premium capacity. There are no restrictions on the source data stream.
Linked tables will only work properly in the new Power BI workspace, and similarly, all linked data flows must be located in the new workspace.
Please turn off the Enable Load option for referenced queries to prevent data from being materialized and introduced into the store. Here, you can reference queries that have enable loading = false and set enable loading to on only for the generated queries to be materialized.
For more information on this see:
Link tables between dataflows - Power Query | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
1 Reply
Hi nikhil0511 ,
After linking or referencing tables between data streams, the source and target data streams need to be refreshed to ensure the latest data is available.
Linked tables require a Power BI Premium subscription to be refreshed. Linked tables can be used in any data flow within a workspace hosted on Power BI Premium capacity. There are no restrictions on the source data stream.
Linked tables will only work properly in the new Power BI workspace, and similarly, all linked data flows must be located in the new workspace.
Please turn off the Enable Load option for referenced queries to prevent data from being materialized and introduced into the store. Here, you can reference queries that have enable loading = false and set enable loading to on only for the generated queries to be materialized.
For more information on this see:
Link tables between dataflows - Power Query | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!