Developer

Murray Brown

<div>
<div class="content wysiwyg-content fr-view">
<p>Hi</p><p>In Power BI I have two queries that are joined to each other. How do I merge the data yo form a new query? The existing relationship is shown in the second image, I am not sure which join to do to match this is</p><p><a href="https://filedb.experts-exchange.com/incoming/2021/12_w50/1579116/Image1.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/12_w50/1579116/Image1.PNG" class="fr-fic fr-dib"></a><br><a href="https://filedb.experts-exchange.com/incoming/2021/12_w50/1579120/Image1.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/12_w50/1579120/Image1.PNG" class="fr-fic fr-dib"></a><br><br></p>
</div>
</div>


Image1.PNG


Hi
In Power BI I have two queries that are joined to each other. How do I merge the data yo form a new query? The existing relationship is shown in the second image, I am not sure which join to do to match this is

Power BI Copy joined tables to Excel

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.