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.
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?
Solved! Go to Solution.
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.
Hi @Anonymous,
Could you please mark the proper answer as solution or share the solution if it's convenient for you?
Best Regards!
Dale
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.
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
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |