Auto increment id

Copper Contributor
How do I add auto increment on excell after downloading excel document from Microsoft forms pro, it's comes with Id on forms but on pro no id
5 Replies


That is not an auto increment Id, its a response Id of the response, try deleting one response in the middle.. Forms Pro is not sending this data when exporting responses.



@Ramteja  thanks, i wanted to use excel data to generate powerbi report  from forms pro any suggesting? 

@Munez What kind of report you are trying to generate?
Based on your requirement we can give you suggestions


something like this


Better follow the below documentation to generate power bi reports from CDS than from static excel.


Once you connect the CDS to power bi, you can schduele refreshes from CDS so that your data gets refreshed periodically.