Jul '24 (edited) • 🤓 Tech Chat
DataFlow Gen 2 Sharepoint Folders
Hey Everyone!
I need some advice on this :p
I can manage a sharepoint folder.
In this site, I have "category folders" (eg. Brand 1)
and in each category, "data folders" (META, Google Analytics / etc...)
Eg.
Brand 1
- META
- Google Analytics
- Sales
I cant get the site URL for brand OR data folders, "META Insights" for example.
which I cant use to query.
My current approach is
For each of the data folders
- Connect to the site URL https://XXX.sharepoint.com/sites/AAA
- Combine all the files in the SiteURL
- Filter the folder path path to the data folder of interest
So assuming I have 10 categories, and 10 data folder in each, I would have 100 queries performing those connection and filtering...
Which is kinda weird cuz for "Step 2" above, I would be combining all the files and then filtering to get 1 out of 100 "folder paths" each time.
Is there a better way to do this?
Is there a way where I can directly connect to the folder path without filtering? 😅
With Utmost Gratitude,
Zyon Wee
0
1 comment
DataFlow Gen 2 Sharepoint Folders
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+30
2
+24
3
+19
4
+15
5
+13
Powered by