Accessing Version date in PowerBI

Hey, team!
Is the possibility to get the commit date available? Couldn’t find this property. Maybe is it a function?

1 Like

@wlipemoura good ping on an old thread.

In the meantime, you can make a query that just gets you version dates like this:

let
  response = Speckle.Api.Fetch("https://app.speckle.systems", 
    "query($projectId: String!, $modelId: String!) {
      project(id: $projectId) {
        model(id: $modelId) {
          versions(limit: 100) {
            items { 
              VersionId: id 
              createdAt 
              message 
            }
          }
        }
      }
    }", 
    [projectId = "3b81e5731b", modelId = "df67438eb3"]
  )
in
  Table.FromRecords(response[project][model][versions][items])

You can then add a many-to-one relation between your normal Speckle Query and this to make the date available to slicers

Alternatively you can perform a table join if you need the version date as a column in the objects table - probably unlikely, but we can show this method as well.

This approach may well be preferable to adding the version date as a column of data by default, simply as less data = quicker dashboards

1 Like