To load this Excel file in Power BI, I’ll just use standard functions and define a first table “Source” that won’t be enabled to load in report.
My next task will be to create a table (or dimension) with the different questions. I also want to include a hierarchy in this dimension: I should be able to browse the questions by categories and sub-categories.
Let’s create a new table named “Question” by referencing the “Source” table. Then remove the other columns than A and B.
The curse of Excel is that it’s so easy to build a data set in strange ways that make it hard to integrate later.