Forum Discussion
Mass Data Editing Query/Data Modelling
Afternoon, So, I have a Power BI report linked to an excel file. This excel file charts performance statistics for various stakeholders across different metrics (inspected, passed, pass rate ...
Hi dcadwallader,
I am unsure exactly of your data structure, but if you had to Unpivot the data, would you then not go from 1590 columns to possibly 3 - 4 columns?
And then you could simply update it from there?
Hi GilbertQ
Would love that to be the case but the table isnt pivoted.
It's simply that wide.
Cheers for getting back though.