Forum Discussion
Anonymous
6 years agoNot applicable
Web API connection - Logical operator help
Hi all, I have a Web API connection set (CRM tool) set and i want to extend the data based on the value of 'Type' field. The Type field contains 10 possible values. I want only 3 of them. T...
- Anonymous6 years ago
Thanks for your help. The issue is fixed by adding '&' for each type.
Anonymous
6 years agoNot applicable
Thanks for your answer. Yes it will impact the performance this is why i need to get only those values.
Sorry i'm very new with this, where can I found the API syntax?
v-chuncz-msft
6 years agoCommunity Support
Anonymous
You may refer to the post below that invokes Custom Function in Query Editor.
http://community.powerbi.com/t5/Desktop/Create-tables-based-on-all-Query-Parameters/td-p/345947
- Anonymous6 years agoNot applicable
Thanks for your help. The issue is fixed by adding '&' for each type.