Auto increment id

New 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

@Munez 

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_0-1582093056910.png

 

@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

@Ramteja 

something like this

@Munez 

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

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-powerbi/

 

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