Forum Discussion
CSV values
Yes. Split and then unpivot.
Thats weird after I unpivot the new columns it showing this error
We couldn't parse OData response result. Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value.
Any idea what could be? Note the data was being pulled from sharepoint
If you delete that last step "Value", does the pivot succeed?
Hi dramus,
The last step("Value") only shows up when I click on an error. Even I deleted it still does not work.
Hi Dramus,
I was able to solve the issue but its doesn't turn out to be what I was expecting. I use the unpivot but result is somehow the same with splitting a column into multiple rows instead of column. And also I had to do this with other column does it mean each column with CSV on it I had to create a new data source?
TootsiePatootsiI mentioned you at the start of the thread, you have to split it to rows and eventually that is what unpivot did.
Regarding you have to create it for each column, it all depends what you are trying to do and what is the end goal. For now, solution was provided to get you the answer for your question but if there is something more required, list the full table columns and desired end result, it will help to provide you the best solution.
TootsiePatootsiWe are working against the very limited dataset you provided (2 columns, 3 rows). If you can provide something that's closer to your real dataset, we might be able to give you an answer, but with what we have at the moment, I'm not sure that we can reproduce what you are trying to do and give you an exact answer.
Can you share (even privately) your PBIX file?
Sorry about that I am new to PowerBI I didnt expect that it unpivot will be the same result. I am thinking of having multiple copies of my datasource(referenced to my original one) for each fields with CSV on it. Now since I have multple datasource. Now since I have multiple data source I am not sure how can I make them be filtered by just 1 slicer
HI Dramus,
Sorry but I cannot share the pbix its quite to confidential. I ended up having multiple datasource for each fields that has CSV. Not sure now how to use slicer filter graphs/report that came from different data source
Without knowing more about your model, I'm not sure I can give you any advice on how to make the filters work.
