Featured Table not populating in Excel

[BIanon]

Hello Community,

I have a table in my dataset which is not related to any other tables. This table has two columns: [Name] and [Brand].

Sample data:

Name	Brand
name 1	Brand 1
name 2	Brand 1
name 3	Brand 1
name 4	Brand 1
name 5	Brand 1
name 6	Brand 1
name 7	Brand 1
name 8	Brand 1
name 9	Brand 1
name 10	Brand 1
name 11	Brand 1
name 12	Brand 1
name 13	Brand 1
name 14	Brand 1
name 15	Brand 1
name 16	Brand 2
name 17	Brand 2
name 18	Brand 2
name 19	Brand 2
name 20	Brand 2
name 21	Brand 2
name 22	Brand 2
name 23	Brand 2
name 24	Brand 2
name 25	Brand 2
name 26	Brand 2
name 27	Brand 2
name 28	Brand 2
name 29	Brand 2
name 30	Brand 2
name 31	Brand 2

Name is both 'Row label' and 'Key' column.

I have aslso tried to create a concatenated col and use that as key col

The data type does appear in Excel but no matter what value from the table I type in there are no matches. No matter what I type in the cell no matches are found. I have tried all exact value from both columns as well as the concatenated key col.

I should be able to type in the row label value and retrieve data based on that, right?

[BIanon]

Unfortuately no, I tried for a days time and then just gave up on using it.

Might revisit the feature sometime in the future and see if it works.

IMO it's a general trend for Microsoft when implementing Excel into anything modern, implementing gets let go half way through and then it's dropped when no one uses it. Excel sheets in PBI service being dropped as the prime example.

[jelgerbos]

Hi Blanon, were you able to find a resolution for this? I am facing the same problem.