Employee timesheets in Sharepoint list
Dear all, I want to setup a sharepoint list where hundreds of employees will fill in simple events occuring during workday. For example: TaskName (fromDropDown), StartTime, EndTime. I expect there will be 100k rows after one year of filling this list. Can Sharepoint list support such large amount of data? Will I be able to retrieve data from the list using PowerBI? Web search provides links to documentation where some sources note that there is a limit of 5000 rows in SP list, other documentation provides that actual capacity is 30 million rows.
Import SharePoint Online list data to On premise SQL server database using SSIS
Hello Community, I am trying to import SharePoint online list data to SQL server using SSIS. I have connected this using O Data Source Editor. I can see all the columns except the choice type columns in SSIS destination mapping. Is there any different approach to do this ? Any help is greatly appreciated! Thank you