Dynamically/automatically add columns/fields to a table visual

Hi Anonymous ,

if you want your power bi report to respond to new fields automatically, I think you have to look into the 'Unpivot other columns'-function in Power Query. Select the userID column in power query, and unpivot other columns. This will give you a structure that can be handled in Power BI. E.g. if you get a new video, and you have video in the legend of a chart, the new video will show in the legend as soon as the dataset is loaded.

Using the unpivot function results in an attribute column and a value column. You might have to split the value column, as this will contain both text and date.

I am not saying it will be easy to create a report on this dataset, but it will be possible: dataset

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.