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

Memberships

Learn Microsoft Fabric

12.7k members • Free

2 contributions to 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: 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 ;)
Unexpected error dispatching create semantic model to portal ms fabric lakehouse
Hi All, I'm testing one of leakhouses for one of my exsisting PBI reports and workspace and when I trying to create a new semantic model I have below error: unexpected error dispatching create semantic model to portal ms fabric lakehouse There is no explanation in MS Community web page, I can modify default semantic model in the warehouse but this error is limiting my actions. Do you have any solutions to it? :)
1 like • Apr '24
Hi Will, It looks like a global MS error, screen matches mine case. I’m an admin of this workspace, lakehouse is working, I can modify default model. https://community.fabric.microsoft.com/t5/Service/Get-Unexpected-error-when-creating-semantic-model-of-a-lakehouse/m-p/3805241#M227538
1 like • Apr '24
For those who facing that problem, the solution is enabling sensitive labels in tenant settings, hard reload the lakehouse pane and try creating a new semantic model.
1-2 of 2
Michał Urban
1
1point to level up
@micha-urban-2759
Power BI Dev

Active 486d ago
Joined Mar 5, 2024
Powered by