Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0

Partition partId of table 'TableName' may not operate in Direct Lake mode

I've created a Fabric Warehouse with three tables:

Market

Prosduct

SellOut

Market and Product are filled by a Lakehouse with a sql Insert statment

SellOut is filled processing local csv files in python

After create a new Semantic Model (not using the Default one)

I was able to create a report in service, I've downloaded the pbix file from service to improve the look and feel and using the Desktop experience.

But after open the pbix file I got this error:

Feedback Type:
Frown (Error)

Error Message:
Partition 'Market-ef6a6f05-0dcc-4f08-a012-d96e6885b80d' of table 'Market' may not operate in Direct Lake mode. This Analysis Services feature is not available in this product.

 

Status: Delivered
Comments
Anonymous
Not applicable

Hi @debiagui ,

 

As the error message shows above,This Analysis Services feature is not available in this product.

Currently, Direct Lake models can only contain tables and views from a single Lakehouse or Data Warehouse.

Direct Lake tables cannot currently be mixed with other table types, such as Import, DirectQuery, or Dual, in the same model. Composite models are not yet supported.

Learn about Direct Lake in Power BI and Microsoft Fabric - Power BI | Microsoft Learn

 

 

Best regards.
Community Support Team_Caitlyn

 

debiagui
Helper II

Ok, but there's no local data inserted, just I've downloaded the pbix from the service.

Is a single Warehouse, with only three tables from that warehouse.

I've reviewed the limitations, and I meet all:

* Only contain tables and views from a single Lakehouse or Data Warehouse.

* No other tables

* No DateTime relations inside

* No Calculated Columns

* Fields in the tables:

Market

MarketId (int)

MarketName (varchar 50)

Cluster (varchar 50)

MarketLevel (varchar 50)

Product

ProductId (varchar 20)

ProductName (varchar 50)

SellOut

Fecha (datetime)

MarketId (Int)

ProductId (varchar 20)

Units (float)