expanding record column

[clintonbreed]

Hi

We have a Sharepoint Helpdesk and I need to create a Report to Show the SLA's for our Business Units.

The Business Unit is displayd as Record and i would like to expand the record to get the Title column and Customer Group Column.

When i Click on the button to Expand the Column, it just keeps Loading. (See Image attached)

I have tried Using advanced Editor to expand the Column but dont have any success. The code i am using is #"BusinessUnit" = Table.ExpandRecordColumn(#"BusinessUnit", {"Title", "CustomerGroup"}, {"BusinessUnit.Title", "BusinessUnit.CustomerGroup"})

Can anyone please assist as i need to have these to Columns (Title and CustomerGroup) in the same table as all the other columns

[Eric_Zhang]

@clintonbreed

Can you click the highlighted "record" in that column to see what's inside? By the way, what is the data source in your case?

[clintonbreed]

Hi, i am using sharepoint online as the data source. the columns inside the record that i want is Highlighted in yellow

[Eric_Zhang]

---

@clintonbreed wrote:

Hi, i am using sharepoint online as the data source. the columns inside the record that i want is Highlighted in yellow

---

I'm not familar with Sharepoint, what exact is that in sharepoint, a list or whatever? I'd like to try reproduce your issue if I could get more details.

By the way, could you try to filter your orginal dataset to have only one rows and then try to expand. I doubt it is some performance issue.

[clintonbreed]

The Customer Column is a Lookup to a List where all the Customers and Customer Groups are Listed

If i Take Customer/Business Units and add it as a new Query and convert it to a table, then i am able to Expand the Record. The Only problem is between the 2 Tables, none of the information is the same to create a relationship. that is why i would like to expand the column in the current table it is in.