Forum Discussion
DirectQuery way to do something like Text.BetweenDelimiters?
Hello,
I have a DirectQuery database that is pretty large, so I can't do the import. I have been attempting to add a column to my table in PowerBi and it keeps saying when I use Text.BetweenDelimiters that it results in a query not supported by DirectQuery. In my table I have a text note that is formatted to a pattern, and I am attempting to grab the date from a specific portion of the note so that power BI can use that date as a filter.
I am new to DAX so I might be missing a function that I can use in DirectQuery and my search didn't result in any options that are supported. Anyone able to help? Or is this just impossibile using directquery?
I don't think its possibile with Direct Query. I want to do something with M and Text between delimiters, nothing worked I kept getting an incompatibility message. In DAX where the screenshot is, it also gave me warnings about even Find. Eventually I did get that to work by allowing incompatible querys in the settings menu. But, it didnt work exactly as I intended.
3 Replies
Hi Anonymous,
It seems you used a Power Query function rather than a DAX function. What's the patten of the column? Than we can find a DAX function here. The LEFT, RIGHT and MID could help. Please gave a sample.
You can add a new column as the picture shows.
Best Regards,
Dale
Hi Anonymous,
Could you please mark the proper answer as solution or share the solution if it's convenient for you?
Best Regards!
DaleI don't think its possibile with Direct Query. I want to do something with M and Text between delimiters, nothing worked I kept getting an incompatibility message. In DAX where the screenshot is, it also gave me warnings about even Find. Eventually I did get that to work by allowing incompatible querys in the settings menu. But, it didnt work exactly as I intended.
