A big congrats to the following top contributors in the community for the month of June: 🥇 @Yu Zheng 🥈 @Abdelhak ㅤ 🥉 @Richard Pařík Thank you all for your contributions to the community, you have all won a free pass to Fabric Dojo for the month of July🥳 If you're new to the community, every month, we give away three one-month passes to Fabric Dojo for the top 3 contributors in the community, as per the 30-day leaderboard! How do you climb the leaderboard? Read this. Well done to everyone 💪

Yesterday, Microsoft introduced two new functions to the Fabric Data Warehouse, you can read more about them in their blog posts here: OPENROWSET ( Press Release || Documentation ) OPENROWSET allows you to preview the data inside a CSV or Parquet in ADLS GEn2 or Azure Blob. Can also be used with INSERT INTO to pre-filter/ transform data from a CSV/Parquet into a Warehouse table. BULK INSERT ( Press Release || Documentation ) BULK INSERT is very similar to COPY INTO, but provides a few extra configuration options: - CODEPAGE: This option allows you to load textual files encoded using national encoding. - DATAFILETYPE: This option enables you to read single- or double-byte file formats or native formats produced by SQL Server on-premises. - FORMATFILE: This option allows you to define column and type mappings in a separate textual or XML format file. How are you going to be using OPENROWSET and BULK INSERT?

Hello everyone, could anyone help me with this? Since yesterday, I've been having problems trying to access my Fabric space. My PC is overloaded (CPU sometimes increases up to ~75%) to open any item on Fabric. When I try to do the same thing with another PC, everything works fine threre! Even after restarting my machine several times, or even disabling automatically launched applications, I can't figure out what the real problem is. Please find attached the dignostic protocol for this crash problem (error-diagnostic-xxxxxx.txt) and some infos about my (PC) system. It all started when my objective was to obtain a list of Delta folders and tables in Fabric Lakehouse with the following code snippet (see code_get_list_LH.txt). Could I have made a mistake? ( The code reference can be found here : https://fabric.guru/getting-a-list-of-folders-and-delta-tables-in-the-fabric-lakehouse Thank you in advance for any reply or any hint which I could do with this issue! Have a nice weekend :) BR, Franck

Welcome to all new members, here's some links and information to help you get started! 𝗤𝘂𝗶𝗰𝗸 𝗟𝗶𝗻𝗸𝘀 𝘁𝗼 𝗴𝗲𝘁 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 - For an introduction to this community → Explore the Welcome Pack - New-ish to Fabric? → Check out our Fabric Foundation module - Studying for the DP-600? → Check out the DP-600 Module and the DP-600 category - Studying for the DP-700? → Check out the DP-700 Module and the DP-700 category - Want to get hands-on? → Check out Fabric Dojo 𝗛𝗼𝘄 𝘁𝗼 𝗲𝗻𝗴𝗮𝗴𝗲 𝘄𝗶𝘁𝗵 𝘁𝗵𝗲 𝗰𝗼𝗺𝗺𝘂𝗻𝗶𝘁𝘆? - Share your knowledge and experience! Even if you're relatively new to Fabric, or the community, your opinion and experiences are valued here! A great way to earn your first point(s) is to introduce yourself in the thread below 👇😀 Thank you for engaging and joining us on this exciting learning journey! 🙏 Will