Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |