Export Performance analytics results

[Jacob64]

Hi all,
We are working with Performance Analytics but more and more pa_scoreswe also use PowerBI.
Now we consider to bring the PA reports to PowerBI including al PA results we gathered through the years.
Previously we where able to see these results but as ServiceNow is changing appearently that changed as wel and we can not find the old PA results anymore.
And whitout these results we can not report about history like we did before and have to start all over again?

I believe the data was to be found in the "pa_scores" but that is empty and I read that pa_scores1 or pa_scores2 are also possible available but where is see an empty list at pa_scores there is an error on the other 2.

also when i check the Analytics hub at some reports i'm able to see results but there is no way to see the location of the result data So at this moment i'm lost.

Does anyone have a suggestion how to see the PA result data in a list so I can either export it to an excel of even better refer a coonection from out datalake to this list?

Many thanks in advance.

Kind Regards,
Jacob.

[Tai Vu · Accepted solution]

Hi @Jacob64 

In Istanbul, the Scores [pa_scores] table was split into Scores Level 1 [pa_scores_l1] and Scores Level 2 [pa_scores_l2]. The pa_scores_l2 table contains the second-level breakdown matrix of scores and the pa_scores_l1 table contains all other scores. 

You should be able to find all the PA score related to Indicators and Breakdowns within the Score Level 1, and all the score of breakdown level 2 in the Score Level 2 table.

Cheers,

Tai Vu