Forum Discussion
PowerNewUser
Resolver I
Resolver ILoading an existing dataset/semantic model to Lakehouse
I have a dashboard that has been created by another department and I need to pull some of the data from it into our lake house. We are currently doing it manually where we export the data of a visual...
Adding what I did for reference-
- added a notebook with following code
# import fabric
from sempy import fabric as FabricDataFrame
# read the table
df_tables_ReqInfo = FabricDataFrame.read_table(workspace ="....." , dataset="....." , table="...")
# drop any extra columns
df_tables_OffersHireData.drop(['....', '.....'], axis = 1, inplace=True)
# write to lakehouse
df_tables_OffersHireData.to_lakehouse_table(name="....", mode="overwrite" )2. Created an enviroment to preload the semantic-link library and set it to as default for workspace - this is required if you want to call the notebook in a pipeline as pip is not allowed at that time.
Doew the dataframe name change from "df_tables_ReqInfo" to "df_tables_OffersHireData" have any effect?
PowerNewUserResolver I
Resolver Ithats just a typo..I had two tables I was processing and ended up removing the middle steps..was trying to explain the solution without exposing my table/column details.