Forum Discussion
Solved
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...
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
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