Skip to main content
Solved

Using Attain OData in Power BI

  • June 2, 2022
  • 1 reply
  • 170 views
J
Enthusiast

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.

Thanks

Best answer by Georgie

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.

Georgie

1 reply

Georgie
Rising Star
Forum|alt.badge.img+1
  • GeorgieRising Star
  • Rising Star
  • Answer
  • November 9, 2022

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.

1 Attachments
Terms & ConditionsAccessibility statement