Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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.BetweenDelim...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you?

 

Best Regards!
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.