Hey Everyone! I need some advice on this :p I can manage a sharepoint folder. Example of site URL : https://XXX.sharepoint.com/sites/AAA 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. The link is would be "https://XXX.sharepoint.com/:f:/s/AAA/[some really long string]" which I cant use to query. My current approach is For each of the data folders 1. Connect to the site URL https://XXX.sharepoint.com/sites/AAA 2. Combine all the files in the SiteURL 3. 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

Notebook execution failed at Notebook service with http status code - '200', please check the Run logs on Notebook, additional details - 'Error name - AnalysisException, Error value - org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.)' :

Hey there Everyone! I've a query that I hope someone could advice me on. I've watched all of Will's videos too, and seek validation and guidance on how to apply it into practice 😜 I know I'm very vague HAHA but this are the information I have to work with for now Suppose that I have a case as follows: 1. I am transitioning from PowerBI into Fabric 2. I'd like to connect different business units (IT, Sales etc.) across a few countries. 3. The data mainly consist of Google Ads (Provided by a service, so technically I'd have the CSV files only haha) and Google Analytics. 4. Architect with the intention to perform predictive analysis in the future The following is my proposed approach: 1. Capacity is segragated by region. (I need advice on how much CU is required or how to know how much CU should I purchase) 2. Power Query to connect to Google Analytics. 3. Lakehouse to store Google Ads CSV files and a datapipeline to clean and transform

👋 First things first - welcome to all the new joiners! 🤝 We have a bit of a tradition here for new joiners to introduce themselves just so everyone can say hello and learn about the amazing people (you!) that are regularly joining the community. It also helps me understand more about what you are looking to get out of the community (so I can make it a better experience for you!). 💬 So, don't be shy, we're a friendly bunch... feel free to say hello using the following questions as a guide: 1. Which part of the world are you signing in from? 2. What's your background (current role, industry, ambitions for the future)? 3. What attracted you to this community? 4. What excites you most about Fabric? 5. I'm really interested in learning more about _______ ? 6. Are you looking to get Fabric certified (DP-600)? Thank you for engaging and joining us on this exciting learning journey! 🙏 Will