SCCM Template

[cadsystems]

I have succesfully imported the SCCM Template for Power Bi.  I am looking to generate a report with Machine Name, Serial Number and OS.  They have a canned Machine Name and OS report already.  I am trying to figure out how to add a column for Serial Numbert.  I haven't been able to find anything and I am pretty sure I can just do this in SCCM reports but I want it to show up in the dashboard.  

[v-yulgu-msft]

Hi @cadsystems,

I am not familiar with development, I can only provide some generic suggestion. Based on my research, to add columns to existing tables, you could have a look at the following steps mentioned in this blog.

• Change the sql query in the solution template folder C:\ProgramData\Business Platform Solution Templates\Microsoft-SCCMTemplate
• Add the column to the staging and target tables in the destination database
• Update the view in the destination database
• Update the PBIX file

Best regards,

Yuliana Gu