Add an analysis tab using Pivot Tables to an Excel sheet automatically populated by Forms data

Brass Contributor

If Forms responses generate an Excel sheet to hold the data, can I create additional tabs on that sheet to run predefined reports based on Pivot Tables?

 

If I want to use PowerBI against an excel sheet generated by a user created form, where is the excel sheet located so I can link it to PowerBI?

 

Thank you

0 Replies