Forum Discussion
Auto increment id
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
Ramteja
Microsoft
MicrosoftThat 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?
- Ramteja
Munez What kind of report you are trying to generate?
Based on your requirement we can give you suggestions- Ramteja
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.
