Forum Discussion
Custom Connector - CSVs & Xlsx data sources in SharePoint.
Good morning All,
I'm contemplating writing a connector to provide access to various CSVs and Xlsx data sources store in SharePoint.
The dashboard that will consume this will reside in PowerBi service.
Asks:
- Is an on-premises gateway required for this work, or simply at the publication?
- Has this been done before?
- The data sources in SharePoint are updated every 24 hours. Would this pose any challenges for the connector?
Many Thanks, Graham
Yes. The sharepoint connector will let you pick authentication and oauth is one of them. All those common data sources are perfectly configured and ready to use at Power Bi.
Regards
5 Replies
- ibarrau
Super User
Hi. Getting data from many csv or xlsx files in sharepoint is really used by almost all companies. If you sharepoint is online then you don't need a gateway, if you are talking about an onpremise one, then yes you need one.
In case this is online you can check content all over internet like: https://www.youtube.com/watch?v=XuLnSYjmsJo
That will help you connect your data.
If you are working onpremise you would use the "Folder" connector.
I hope that helps,
