Forum Discussion
split by delimiter
hi,
i want to split column by delimiter (to an unknown number of rows)
i can't do it on power bi because the table is very big and this function is not supported on direct query
is someone have a way or function to do this? my DB is SQL Azure Data warehouse
thanks!
Have you tried the split function in T-SQL?
If you encounter any performance issue, I'll suggest you re-model your dataset, say create an extra table that has the data split and use this table in your Power BI report.
Or if you are lucky enough to be using SQL-2016 then you can do it natively now using
2 Replies
Have you tried the split function in T-SQL?
If you encounter any performance issue, I'll suggest you re-model your dataset, say create an extra table that has the data split and use this table in your Power BI report.
Or if you are lucky enough to be using SQL-2016 then you can do it natively now using