Forum Discussion
PATHITEM function to extract string from the URL
Hi,
I'm trying to extract string from the URL using PATHITEM function, it is working fine for DAX when the data is in excel.
Now I'm connect to direct query, i need to use DAX formula compatibilty in DirectQuery mode.
Example:
URL: /country/english/pages/careers/article
I want to extract "careers" in new column.
DAX formula is working fine: PATHITEM(SUBSTITUTE(COLUMN,"/","|"),5)
Could you please help me with the function to do the same for direct query
Thanks
7 Replies
To ensure that queries sent to the underlying data source have acceptable performance, limitations are imposed on measures by default. Advanced users can choose to bypass this limitation by selecting File > Options and settings > Options and then DirectQuery, then selecting the option Allow unrestricted measures in DirectQuery mode.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery
i have turned on that option, it is still not working.
I have tried MID and SEARCH functions, I'm getting error message "Search" and "Find" are not allowed as part of calculated column DAX.
As per the link below: we need to use 4 argumnet instead of 2 argument.
http://community.powerbi.com/t5/Desktop/FIND-SEARCH-in-direct-query-mode/td-p/198993
I'm trying that option but still not luck.
