SalesPrices table in Power BI showing prices for only one item

(0) Share

Report

Posted on by mmarques

Hi,

I'm not sure why but every time I try to download the SalesPrices table in Power BI (via the Dynamics BC connector) it only comes up with one specific product. But, when I look in the system I can see that other items have the prices set up for them as well although they are not showing on the SalesPrices table.

Does anyone have any idea why this would happen?

Thanks,

Mariana

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (1)

Sort by

Suggested answer

MahGah 15,613 on at

Like (2)

Report
Copy link

Link copied!

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
Verified answer

mmarques 40 on at

Like (1)

Report
Copy link

Link copied!

thank you so much this worked!
Amrit 181 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I am facing the same issue, i tried the posted solution, but it didn't work for me. I applied the Item No filter to * and tried to remove the ItemNoFilterCtrl, but when the uploading the webservice to power Bi, it again filtering the data t for one item only. Is there any other solution?