Forum Discussion
Solved
Automate Sharepoint online folder data
how can i automate the process of loading files in folder on sharepoint and loading same files data in power bi?
- use the "SharePoint Folder" connector
- add filters on file name and path to narrow in on just the files you want to combine
- easy option: Combine Binaries. Better option: Write your own ingestor, and then use "Expand Tables"
- change column types as needed.
I was planning to write a blog entry on this ( the better option ). Hopefully I can get to it soon-ish.
- use the "SharePoint Folder" connector
- add filters on file name and path to narrow in on just the files you want to combine
- easy option: Combine Binaries. Better option: Write your own ingestor, and then use "Expand Tables"
- change column types as needed.
I was planning to write a blog entry on this ( the better option ). Hopefully I can get to it soon-ish.