How to Link two pbix files

[myash2211]

Hi

I have a pbix file as ABCD.pbix which I have published in my workspace. I wanted to create another pbix file i.e. EGH.pbix where I want to link the tables of ABCD.pbix so as whenever I refresh ABCD.pbix, the visuals in EGH.pbix also gets refreshed

When I searched on net, it was advised to link using Power Bi semantic models but when I did that I got error Direct Query isn't available for this dataset

Please advise how to link both the tables 

Thanks....Yash

[rajendraongole1]

Hi @myash2211 -  Can you try with Power BI Dataflows or Shared Datasets works as expected with two pbix files to refreshed, the data in another pbix is also updated. These methods provide flexibility and ensure data consistency across reports.

Creating a dataflow - Power BI | Microsoft Learn

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataf...

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!