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.
You can use CONCATENATEX with a carriage return in the delimiter to get that effect. Is your current measure using CONCATENATEX? or is it still a long text string? If the latter, you'll likely want to split the text and unpivot in the query editor, so that you can concatenate it with more flexibility.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thank you for the reply. The data type for the column is text. I would just split it by delimeter then pivot like you said but the query needs to be in "DirectQuery" mode and not in "Import" mode. It wont allow for the data to stay in "Direct Query" if you split the columns by delimeter.
HI cmckinney
As per your explanation, you have to work on the query whic you have written to be uses as a direct query.
This is not a Power BI issue rather you may think about asking help from someone who can get the query to return as required on the Datasource you are pulling it from.
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.