Hello All, I'm new here, new to data science, and new to fabric! I'm trying to consume a Rest API and step one is to save the json response to the bronze layer even before doing any validations. I was hoping to store the result as a json file in the lakehouse but am having difficulty on how to do it. I was able to convert it to a dataframe but haven't found any resources that show how to save it directly as a json file. Working DF Example: from pyspark.sql import Row def get_token(url, data): # Make the POST request response = requests.post(url, json=data) # Check if the request was successful if response.status_code == 201: json_response = response.json() lakehouse_path = f"Files/auth.json" data = [Row(**json_response)] df = spark.createDataFrame(data) df.write.json(lakehouse_path) I'm curious how to store the raw files directly (not a dataframe). I would like to solve this problem as I'm also interested in saving image files which will be fetched from the api at a later date. Thanks for your time!

Learning Fabric is a marathon, not a sprint. So let's celebrate the small wins we make along the journey. Share any recent wins you've had with Fabric in the comments below! Perhaps this week you: - successfully shortcuted into Amazon S3? - built a Snowflake mirrored database? - learnt some new data modeling techniques? - build your first eventstream to process real-time data? LET'S HEAR ABOUT IT!

My 60-day free trial is coming to an end... after 383 days (thanks Microsoft) 😂 Yours probably is too. The question is, are you prepared? What are your options? 1. You can purchase a F-SKU capacity from the Azure Portal, and reassign your existing workspaces to that new capacity. Or, 2. If you're still not ready to buy an F-SKU yet, the documentation states you can create a new trial capacity with a new user, and reassign your workspaces to that new trial capacity. 3. Any others? Let me know! Important things to note: - If you don't upgrade to a paid Fabric capacity before the end of the trial period, non-Power BI Fabric items are removed according to the retention policy upon removal (I believe this is 7 days soft delete, but double check, and also don't let it get to this!)

When authoring a notebook from the fabric web interface I see an option to open the notebook in VS code. This opens the notebook locally on my PC. The issue I'm dealing with is that is not able to authenticate with the workspace / lake house from my local notebook. I assume there is a something we need to do to configure spark authentication, however when browsing the lakehouse in fabric i'm only able to find the "SQL Connection String" but no other credentials. I assume this is a solve problem since the main purpose of these notebooks is to read/write data, however I can't find any documentation on it. Example: flat_df.write.format("delta").mode("overwrite").save("Tables/auth_result") The above works from the online fabric notebook, but fails with the following error when opening the notebook with VS Code and trying to execute the same line. ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it Any help would be greatly appreciated!

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