I have few csv and excel files in SharePoint.
I want to access them in power bi. On what basis do I decide between using the power bi sharpeoint folder connector or the power bi web connector.
With SharePoint folder connector, you will only have the one credentials to maintain, whereas with Web connector, you will have credentials per file to maintain.
Web connector is faster as you are going direct to one file. SharePoint folder connector is more robust of the two if you are loading more than a couple of files from the same SharePoint folder.