Forum Discussion

cadsystems's avatar
cadsystems
Regular Visitor
8 years ago

SCCM Template

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.  

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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