Forum Discussion
Multiple lines text in a table or Matrix
Anonymous, it appears not to be SQL related but a direct issue with PowerBI.
I have made contact witht hem and they are activly looking into this.
My way around this for now is to pull the data into a pivot table in Excel and use the workbook function now available in BI, not ideal but a work around.
Thanks for your help.
Hi Anonymous,
The data is presently using a SQl query to do so, so yes I can.
Not sure how to do as you suggested. Can you point me in the right direction?
Thanks
Craig
CraigBlackman There are multiple ways to accomplish this. This forum has several different solutions to the problem, in your case you would just change the comma delimiter to double space.
http://stackoverflow.com/questions/5493510/turning-a-comma-separated-string-into-individual-rows
Anonymous, it appears not to be SQL related but a direct issue with PowerBI.
I have made contact witht hem and they are activly looking into this.
My way around this for now is to pull the data into a pivot table in Excel and use the workbook function now available in BI, not ideal but a work around.
Thanks for your help.
CraigBlackman Interesting... Thanks for the update. I'd be interested in hearing what exactly the issue was... Treating hidden characters differently, etc.
Anonymous, I'll keep you posted.
I gues that someone could get over this with a custom visual, unfortunately I don't know enough about code to do this.
Hi Craig,
Kindly expain how you solved this.
Thanks
Vishy
Hi Craig,
Kindly expain how you solved this.
Thanks
Vishy
