Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Learn Microsoft Fabric

14.3k members โ€ข Free

7 contributions to Learn Microsoft Fabric
Passed DP 600!!
Happy to share I have passed the exam!๐ŸฅณThank you to the amazing DP 600 playlist @Will Needham , and the lot of learnings through the fantastic posts and discussions happening within this communityโค๏ธ
1 like โ€ข Jun '24
Congratulations
Load HTML file Content from Lakehouse Files into Fabric Data Pipeline Variable
What will be the best way to load the content of a HTML file (Ex: template.html that is uploaded to the Lakehouse Files folder) into a String variable inside the Fabric Data Pipeline using some Activity? Thanks, Prabhat
Need help to format Array variable in Pipeline as HTML
Hi friends, I am new and exploring Pipeline. I have a Array variable that stores below content from the Activity output. How can I format this to a HTML table so that I can send the message using either Teams or Office 365 outlook Activity. Please suggest. { "name": "Combined_Execution_Result", "value": [ "{\"source_table_name\": \"EHS\", \"target_table_name\": \"FinalValues\", \"rows_inserted\": \"0\", \"rows_updated\": \"44\"}", "{\"source_table_name\": \"STP\", \"target_table_name\": \"FinalValues\", \"rows_inserted\": \"0\", \"rows_updated\": \"22\"}" ] } Thanks, Prabhat
0
0
Returning Values from a Notebook
Hello friends. I have a Notebook that has few parameters that are used for Data processing, like SourceTable, TargetTable etc. The Notebook then loads data from Source and upsert to Target after some transformation. The notebook store the rows_inserted and rows_updated in 2 variables. This Notebook is called from a Fabric Data Pipline. I want help to return these rows_inserted and rows_updated variables to the caller Pipeline. How can I do that? Thanks, Prabhat
1 like โ€ข May '24
Got it, I will try that and let you know. Thank you @Vinayak K
2 likes โ€ข May '24
@Vinayak K Keeping the exit statement in a separate cell works fine. Also I tried to keep the exit statement inside finally too worked. So thinking what will be the preferred way? Separate cell or finally? Please suggest. json_result = json.dumps(result_dict) except Exception as e: print("Write operation failed: ", str(e)) mssparkutils.notebook.exit(1) finally: mssparkutils.notebook.exit(json_result)
Help with notebook reference.
Hello Skool, I need a little help. I'm not sure if it's possible to do what I'm thinking. Is it possible to run a cell from another notebook? I know that I can run a whole notebook from another notebook, using the command %run 'Name of the notebook' But is it possible to run only a cell? and how should I insert the reference in the "source" cell? I've been looking for this on these links: Introduction to Microsoft Spark utilities - Azure Synapse Analytics | Microsoft Learn How to use notebooks - Microsoft Fabric | Microsoft Learn Thanks.
2 likes โ€ข May '24
Having a 3rd notebook with just the content of the cell as UDF and executing from required file is the approach, as Vinayak suggested earlier.
1-7 of 7
Prabhat Nath
2
4points to level up
@prabhat-nath-5961
Learning Fabric and PySpark.

Active 557d ago
Joined May 18, 2024
Hyderabad, India
Powered by