How do I import or export a table from one Power BI dataset to another automatically?

[PerO_MP]

I have two datasets in Power BI (separate pbix files), and I would like to automatically connect one or more tables from one data set to the other. I also want to connect tables in the other direction. Both datasets are continuously updated, and I like them to update each other when the datasets/files are refreshed. I have a Power BI Premium license.

[sanalytics · Accepted solution]

@PerO_MP  Below are the step by step guide which i want to refer.
1) Go to Power BI service and Create New Dataflow option.

2)Import the required tables from both datasets using Power Query.

3)Transform the Dataflow as needed and Save and refresh the dataflow.

4)Open both pbix file and connect the created dataflow by using dafalow connector.

5)load the necessary tables.

6) Now, both the datasets referencing both centralized dataset and will synced when it will refreshed.

Hope it will help..

Regards

sanalytics

If it is your solution then Please Accept it as your solution and like.

[v-hashadapu]

Hi @PerO_MP , Just checking in—were you able to resolve the issue?
If one of the replies helped, please consider marking it as "Accept as Solution" and giving a 'Kudos'. Doing so can assist other community members in finding answers more quickly.
Thank you!

[v-hashadapu]

Hi @PerO_MP , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @PerO_MP , Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu · Accepted solution]

Hi @PerO_MP , Thank you for reaching out to the Microsoft Community Forum.

The best approach in a Power BI Premium workspace is to use dataflows with linked tables combined with Power Automate to orchestrate refreshes. Start by publishing both .pbix files, let’s call them Dataset A and Dataset B to the same Premium workspace. Then, create two separate dataflows in that workspace, one for each dataset. In Dataflow_A, connect to Dataset A using the “Power BI semantic models” source, selecting the tables you want to expose. Repeat the same for Dataflow_B with Dataset B. Next, in Dataflow_A, link tables from Dataflow_B and in Dataflow_B, link tables from Dataflow_A. This enables the bidirectional sharing of tables between the two datasets via dataflows, all within the same workspace, which is required for linked tables to function properly.

Update both .pbix files to load data from their respective dataflows using Power BI Desktop and publish them again. You can optionally use DirectQuery instead of import mode when connecting to the dataflows for real-time updates but note that this may impact performance with large datasets. In either case, the linked data from the other dataset will now be available in each .pbix and they will remain synchronized as long as dataflows are refreshed in the correct sequence.

To ensure updates happen automatically and in the right order, create a Power Automate flow. Set it to trigger when Dataflow_A completes its refresh. Then sequentially add actions to refresh Dataset A, Dataflow_B and finally Dataset B. This guarantees that changes in either dataset are propagated through their respective dataflows and reflected in the other dataset. You can still configure time-based refresh schedules in Power BI Service as a fallback.

Lastly, take advantage of Premium optimizations like Enhanced Compute Engine for faster refreshes and Incremental Refresh for large tables. Monitor your refresh history to ensure reliability and avoid circular dependencies by keeping linked table chains under 32 references.

If this helped solve the issue, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.

[sanalytics]

@PerO_MP 
Good options, you can create dataflow by connecting the tables of two datasets and create a separte datasets for that and scheduled the dataflow refresh after your two datasets refresh..When the both datasets will get refsrehed your dataflow will be synced as well.
Otherwise,you can create Power Automate flow for that scenario as well.

Regards,

sanalytics

[PerO_MP]

Thanks Sanalytics, is there a more comprehensive description of this you can point at, like a step-by-step description including necessary "stuff" in the background making it possible to work?

[sanalytics · Accepted solution]

@PerO_MP  Below are the step by step guide which i want to refer.
1) Go to Power BI service and Create New Dataflow option.

2)Import the required tables from both datasets using Power Query.

3)Transform the Dataflow as needed and Save and refresh the dataflow.

4)Open both pbix file and connect the created dataflow by using dafalow connector.

5)load the necessary tables.

6) Now, both the datasets referencing both centralized dataset and will synced when it will refreshed.

Hope it will help..

Regards

sanalytics

If it is your solution then Please Accept it as your solution and like.