Forum Discussion
Featured Table not populating in Excel
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?
2 Replies
Hi Blanon, were you able to find a resolution for this? I am facing the same problem.
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.
