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
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
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.