Forum Discussion
Creating rows within a a cell.
Hi cmckinney ,
The split function is not supported in Direct Query mode.
Please refer to Direct Query limitations.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
If your data source is SQL Server, maybe you can use SQL statements to pre-process when connecting to data sources.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi cmckinney ,
How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.