Hi
I experienced similar issue as well. Looks like web service has a "ItemNoFilterCtrl": that always default to one item number. I do not know why.
You can try the following and test
In BC go to Web Service and follow the below guideline. You can use any name you want to (I used Sales_Price_3). the important steps are
1) Make sure to add Filter for Item No as *
2) After publishing this in Power BI use this Web service (anything you name it)
3) If results are not acceptable go back to filter and change some filters and publish again. Use Edit Existing instead of Create new






