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.
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.
The source is configured as below :
...api/xml/Tickets?DateCreated=20190311000001&Type[contains]=Enhancement&pageSize=2000"
How can extend the data to be Type[contains]=Enhancement OR Type[contains]=Access OR Type[contains]=Defect
Thanks for your help
Solved! Go to Solution.
Thanks for your help. The issue is fixed by adding '&' for each type.
Does it hurt performance/refresh too much to just bring it all in (remove the existing filter on Type) and filter in query? If so, you'll have to look at the syntax for your API, but does it accept them provided in a comma separated list?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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?
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
Thanks for your help. The issue is fixed by adding '&' for each type.
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |