Power Query Merge Expansion Issue – Expanded Columns Show as Null in Customer Insights Data

(4) Share

Report

Posted on by CU23020349-0

I am using Power Query in Customer Insights Data
merge two tables (FilteredMarketing2 and FilteredAccount1) on tax id using a Left Outer Join.

result from power query: there're data in account.name

After merging, I expand the Account column to include specific fields. it becomes null even there're data.

-------------------

so i change the query to

The expanded data appears correctly inside Power Query, but when I go to Table > Data in Customer Insights, all columns that start with Account. show as null.

Categories:

Dynamics 365 general

I have the same question (0)

All responses (1)

Answers (0)

CU23020349-0 12 on at

Like (1)

Report

I want to expand all and the nested table that has data must not be null and show in Table > Data in Customer Insights

Was this reply helpful? Yes No