Adding new custom fields to the edison365ideas Power BI template

Due to the SharePoint API limitations, Power BI reports have to restrict the fields returned from the list. To add custom fields in you will need to use the advanced editor and update the REST API query as seen below:

1. Steps to include an ideas custom column. Click the Advanced Editor:
   1. 
      
2. This opens a new window:
   1. 
      
3. Scroll the window to the end of the Select query on the second line and add a comma as seen below:
   1. 
      
4. Now type the name of the new SharePoint column that you want to include in the report, if you are unsure of the column name you can navigate to the Fields admin in the edison365ideas UI, click the Idea Fields tab then find the field you want to include in the Power BI Report and copy the “SharePoint Field” value as seen below:
   1.  
      
   2. Add the column to the query in Power Query:
   3. Click Done
5. Now double click the “Removed Other Columns” step and select the new column to include
   1. 
      
6. The column will now be available in the dataset query, change the Type and Rename as needed:
7. Certain columns such as People columns will require the REST query in step 4.b to include an expand, for example:
   
   1. 
      
   2. Then expand the data in the query:
8. The same steps are required to add Challenge columns into the Challenges dataset query.