Forum Discussion
Misq
Helper I
Helper IMeasure table in Lakehouse
Hello all,
I have a question regarding creating a measure table in lakehouse. I readed some materials in web and I'm stuck. Below are steps that I did:
1. I've created a measure table via Notebook:
data = [(1, 'MeasureTable')]
columns = ['ID', 'Col1']
measure_df = spark.createDataFrame(data, columns)
measure_df.show()
spark.sql("DROP TABLE IF EXISTS MeasureTable")
measure_df.write.format("delta").saveAsTable('MeasureTable')
2. In SQL Endpoint I added measures to the table, when I'm clicking New Report button, I can see measureTable, properly formatted. But... there is no option to download this report with connection to SQL endpoint (button is inactive).
3. When I go back to the lakehouse and I creating new semantic model, my measure table don't show measures that I added before to default semantic model in SQL Endpoint. And it show only table added in the notebook:
+--+----------------------+
| ID| Col1 |
+--+----------------------+
| 1 | MeasureTable |
+--+----------------------+
Do you know how to handle that case, where you want to have a default measures added to the model?
I will be very appreciate for your help and advice 😉
1 Reply
Hi Misq ,
Regarding your question, you may be able to create the table with Spark Sql.
Creating Managed and External Spark Tables in Fabric Lakehouse | by Aitor Murguzur | Medium
