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 t...
Need Help
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