Auto increment id

%3CLINGO-SUB%20id%3D%22lingo-sub-1181102%22%20slang%3D%22en-US%22%3EAuto%20increment%20id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181102%22%20slang%3D%22en-US%22%3EHow%20do%20I%20add%20auto%20increment%20on%20excell%20after%20downloading%20excel%20document%20from%20Microsoft%20forms%20pro%2C%20it's%20comes%20with%20Id%20on%20forms%20but%20on%20pro%20no%20id%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1181102%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%20pro%20id%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181176%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20increment%20id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181176%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562798%22%20target%3D%22_blank%22%3E%40Munez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20not%20an%20auto%20increment%20Id%2C%20its%20a%20response%20Id%20of%20the%20response%2C%20try%20deleting%20one%20response%20in%20the%20middle..%20Forms%20Pro%20is%20not%20sending%20this%20data%20when%20exporting%20responses.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ramteja_0-1582093056910.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F171955iE4D263777A29F7B2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Ramteja_0-1582093056910.png%22%20alt%3D%22Ramteja_0-1582093056910.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181527%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20increment%20id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181527%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562829%22%20target%3D%22_blank%22%3E%40Ramteja%3C%2FA%3E%26nbsp%3B%20thanks%2C%20i%20wanted%20to%20use%20excel%20data%20to%20generate%20powerbi%20report%26nbsp%3B%20from%20forms%20pro%20any%20suggesting%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181650%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20increment%20id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181650%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562798%22%20target%3D%22_blank%22%3E%40Munez%3C%2FA%3E%26nbsp%3BWhat%20kind%20of%20report%20you%20are%20trying%20to%20generate%3F%3CBR%20%2F%3EBased%20on%20your%20requirement%20we%20can%20give%20you%20suggestions%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181686%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20increment%20id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181686%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562829%22%20target%3D%22_blank%22%3E%40Ramteja%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esomething%20like%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181698%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20increment%20id%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562798%22%20target%3D%22_blank%22%3E%40Munez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20follow%20the%20below%20documentation%20to%20generate%20power%20bi%20reports%20from%20CDS%20than%20from%20static%20excel.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Fblog%2Fcds-for-apps-powerbi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Fblog%2Fcds-for-apps-powerbi%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnce%20you%20connect%20the%20CDS%20to%20power%20bi%2C%20you%20can%20schduele%20refreshes%20from%20CDS%20so%20that%20your%20data%20gets%20refreshed%20periodically.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.