Forum Discussion
Munez
Feb 19, 2020Copper Contributor
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
Munez
Feb 19, 2020Copper Contributor
Ramteja thanks, i wanted to use excel data to generate powerbi report from forms pro any suggesting?
Ramteja
Microsoft
Feb 19, 2020Munez What kind of report you are trying to generate?
Based on your requirement we can give you suggestions
- RamtejaFeb 19, 2020
Microsoft
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.