Forum Discussion
Pivoting Key Value pairs data
I have SQL data which I am reading into PowerBI. The data has a column 'Hits' which has a list of key value pairs in each row. I need to extract the key-value pairs to unique columns based on the k...
Hi, nicm-cc
how about adding table.buffer() before pivoting the entire table of split the tables into several chunks then perform the pivot then append the result? Though it's a workaround that you will have to do but it may solve your problem.
check the #"Convert to Number" step supports query folding. Query folding.
Also, is it possible to extract the key value pair in the sql source? if so then give it a shot.
Hi rubayatyasmin,
The query does not support query folding as it uses an advanced sql select statement.
I am working on trying to extract a select view from the source itself but this has not proved easy.
