Measure table in Lakehouse · Learn Microsoft Fabric

Measure table in Lakehouse

Hi 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:

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 ;)

8 comments