Create relationship to data within a content pack

[mparowski]

Microsoft has provided us with a content pack with incredible metrics about how people in our company are using Office 365.  I would like to cross-reference the data in the report with some of my corporate HR data (based on email address/UPN), but I don't see a way to create a data relationship between my data and the content pack.  Does anyone know how to do this?  Or can someone confirm that it isn't possible?  I can always pull the report through the admin portal, but I had hoped to automate updates by leveraging the content pack.

Thanks in advance for any suggestions!

[v-yuezhe-msft · Accepted solution]

@mparowski,

It is not possible to create relationship in Power BI Service.

However, you can use Power BI Desktop to connect to Office 365 Adoption PBIT file, then create relationship between tables in Power BI Desktop .

Regards,
Lydia