Forum Discussion
Power M Query - IN Condition
HI Team, Anonymous dax I have tried many formulas and don't seem to get a Power M query working when accessing the WEB API end point . Requirement is to get only a subset of data from the web . e...
Hi Anonymous
The data you can retrieve from an API is determined by the API archtitecture. If it only allows you to retrieve data for 10 products then that's what you have to do.
My understanding from your question is that you want to retrieve data for only 3? That will only be possible if the API works in that way. If it doesn't support the retrieval of data for 3 specific products then you won't be able to do this. You'll have to get data for 10 products then filter out what you don't want in Power Query.
regards
Phil
Thanks PhilipTreacy yes API allows us to query for subset of products .