https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Getting-Data-from-Different-Table/m-p/1229221#M3269 <P>I have a master database with Geo and their regional data for respective quarters.</P><P>Now, I need to bring their Plans from a different table. While bringing the Geo Plan was easy, brining the Region Plans is difficult because they are not always same so cannot create a key. Need help on this.</P><P>Below is how tables look :-</P><P>If you see I have Cloud and AMS_Cloud - So creating key with regions wont help! Any other way to get data from other table besides joining</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shraddha_0-1594927366763.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/313561i1FDDE8CA456DF045/image-size/medium?v=v2&amp;px=400" role="button" title="shraddha_0-1594927366763.png" alt="shraddha_0-1594927366763.png" /></span></P><P>&nbsp;</P> Thu, 16 Jul 2020 19:23:58 GMT shraddha 2020-07-16T19:23:58Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Getting-Data-from-Different-Table/m-p/1229221#M3269 <P>I have a master database with Geo and their regional data for respective quarters.</P><P>Now, I need to bring their Plans from a different table. While bringing the Geo Plan was easy, brining the Region Plans is difficult because they are not always same so cannot create a key. Need help on this.</P><P>Below is how tables look :-</P><P>If you see I have Cloud and AMS_Cloud - So creating key with regions wont help! Any other way to get data from other table besides joining</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shraddha_0-1594927366763.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/313561i1FDDE8CA456DF045/image-size/medium?v=v2&amp;px=400" role="button" title="shraddha_0-1594927366763.png" alt="shraddha_0-1594927366763.png" /></span></P><P>&nbsp;</P> Thu, 16 Jul 2020 19:23:58 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Getting-Data-from-Different-Table/m-p/1229221#M3269 shraddha 2020-07-16T19:23:58Z