Small and medium business | Business Central, N...

Linking Item attributes to items in Power BI

(0) Share

Report

Posted on by nbs3

Hi,

I am trying to link the item attributes to the items in Power BI. I can connect to BC and see the ItemAttribute page, but am not sure how to link this to the Items. I see an ID column in the attributes, but no corresponding column in the Items. How can I make this connection?

All responses (3)

Answers (0)

Suggested answer

MahGah 15,435 on at

Like (0)

Report

RE: Linking Item attributes to items in Power BI

Hi

I am in BC 17.5 SaaS and when I select Page in Web Service I can see the following in my environment. But maybe it is different in yours.

We do not use any attribute and hence I cannot test my theory in Power BI.
nbs3 65 on at

Like (0)

Report

RE: Linking Item attributes to items in Power BI

Thanks MahGah, I tried creating a new data set in web services, but I don't see page 7504 or 9110 as an option to choice. How can I access these?

I can see also 7502 Item Attribute Translation and 7505 Item Attr. Value Translations, but when I try to connect to PBI via OData I get no results.
Suggested answer

MahGah 15,435 on at

Like (0)

Report

RE: Linking Item attributes to items in Power BI

Hi

You need somehow to expose Table 7505 (Item Attribute Value Mapping) to Power BI. Also, you need Table 7500 (Item Attribute) to build that relationship, (Item and ID are in 7505 and ID name is in 7500)

I could not find such a page. But maybe try to expose the following pages to see if you have any success or not

1) Page 7504 - Item Attribute Value List

2) Page 9110- Item Attributes Factbox

Thanks