Left Outer Join Issue

Super User

4 years ago

A few suggetions ....

Suggestion 1:-

I notice you had rows with null Bus_OBJKEY.

Replace Bus_OBJKEY null values with "*" or something else in the first or second table.

Suggestion 2:-

Did you sort the sort table "1Head" by "Bus_OBJKEY" before removing the duplicates?

There is a known bug if you dont do the sort first.

Suggestion 3:-

Are you using the latest version of Power Bi Deskop ?

Unistall the old version and install the latest version.

Suggestion 4:-

What datasource are using? It it some multi row per record datasource like XML or JSON ?

Try check the layout is ok in Excel or Notepad

Suggestion 5:-

Take a backup copy of your PBIX

Then test what does and does not work to pin point the problem.

In Power Query ...

Edit table Block_Log_Base.

Remove all steps except Source

Click on Bus_OBJKEY

Remove all other columns

Clean Bus_OBJKEY

Trim Bus_OBJKEY
Change Bus_OBJKEY to Text data type

Sort by Bus_OBJKEY
Remove blank Bus_OBJKEY

Keep top 1000 rows

Edit table 1Head"

Remove all steps except Source
Remove all columns except Bus_OBJKEY and Document Id

Clean Bus_OBJKEY

Trim Bus_OBJKEY

Change Bus_OBJKEY to Text data type

Sort by Bus_OBJKEY

Remove duplicate Bus_OBJKEY

Merge Block_Log_Base with 1Head as new on Bus_OBJKEY

Expand Document Id

Does this work?

If Yes then start adding the steps you removed back until it breaks ... hence pin pointing the problem.

If No then I am out of ideas . Sorry ☹️☹️☹️

Forum Discussion