Resolve Power BI tables won’t join issue with these steps

3 min. read

Updated onOctober 4, 2023

updated onOctober 4, 2023

Share this article

Improve this guide

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Power Biis a powerful data visualization BI tool fromMicrosoft. This business analytics service enables you to see your data through a single interface. Sometime,Power bitable won’t join issue can occur while relating two tables as reported inPower Bicommunity.

As can be noted in both tables I have the LocOrgTrab_CD and Entidade_ID fields, and through them, I need to somehow relate these two tables to set into one, in the end, I wanted to have a table with the following fields:

If you are also troubled by this issue, here are a couple of troubleshooting tips to help you resolve “Power Bitables won’t join” issue in Windows.

What can I do if Power BI tables won’t join?

1. Use Merge Query

The way it works is that you choose a column that is related to each other from each table and merges them based on the relationships.

Power BI total doesn’t add up? Try these solutions

2. Check the table for empty spaces

3. Use UNION function

ThePower bitables won’t join issues can get complicated if you are new toPower Biservice. However, by following the steps in this article, you should be able to fixPower Bijoin tables issue.

If the issue persists, make sure you ask for assistance in thePower BIcommunity for problem-specific solutions. Don’t forget to leave your solution in the comments to help other users.

Resolve Power BI tables won’t join issue with these steps#

What can I do if Power BI tables won’t join?#

1. Use Merge Query#

2. Check the table for empty spaces#

3. Use UNION function#

Resolve Power BI tables won’t join issue with these steps

What can I do if Power BI tables won’t join?

1. Use Merge Query

2. Check the table for empty spaces

3. Use UNION function