Using Attain OData in Power BI

  • 3 June 2022
  • 1 reply

I was very excited to see the post “Power BI using ClickLearn Data” and have just started to work through all of the additional posts in regards to creating a Power BI dashboard.

However, I am noticing that most of the articles are using data from ClickLearn Classic. We are using ClickLearn Attain and I am having a hard time figuring out what the data means. There was a pdf posted that breaks down the data within the Company Tracking Data, but the data I have has several differences:

  • Different Action item labels
  • intValue2, intValue2, and intValue3
  • txtValue1, txtValue2, and txtValue3

I was hoping someone had some experience creating a PowerBI dashboard using the Attain data who could share any insight, or if there was an OData Attain Document.



Best answer by Georgie 9 November 2022, 17:50

View original

1 reply

Userlevel 1
Badge +1

Hi Jenn,


This is what ClickLearn sent me when I asked them what those fields mean.

I’m still not quite clear on it as the table in the PDF for the int fields is a little confusing, but perhaps this PDF might make sense to you?

I can’t work out which Odata fields are telling me if users have passed the test or not - that’s the main statistic I want, and I can’t see a clearly named field that would tell me that.

Anyway, perhaps this PDF will be of use to you.