cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Re: CSV values

Yes. Split and then unpivot.

Highlighted
Regular Visitor

Re: CSV values

Ill try it out, my data is quite large it takes quite a few minutes for the unpivot. Let you know what would be the result

 

Highlighted
Regular Visitor

Re: CSV values

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

Highlighted
Regular Visitor

Re: CSV values

error1.jpg

Highlighted
Responsive Resident
Responsive Resident

Re: CSV values

If you delete that last step "Value", does the pivot succeed?

Highlighted
Regular Visitor

Re: CSV values

Hi dramus,

 

The last step("Value") only shows up when I click on an error. Even I deleted it still does not work.

 

 

error2.jpg

 

 

Highlighted
Regular Visitor

Re: CSV values

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?

Highlighted
Super User IV
Super User IV

Re: CSV values

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Responsive Resident
Responsive Resident

Re: CSV values

@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?

Highlighted
Regular Visitor

Re: CSV values

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors