web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Linking Item attribute...
Small and medium business | Business Central, N...
Suggested Answer

Linking Item attributes to items in Power BI

(0) ShareShare
ReportReport
Posted on by nbs3 67

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?

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at

    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 
  • nbs3 Profile Picture
    nbs3 67 on at

    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 Profile Picture
    MahGah 15,529 on at

    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. 

    pastedimage1622836890167v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans