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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mkulikowski
Frequent Visitor

Direct lake semantic model with view

Hello,

 

I have views in my semantic model with this weird refresh date and red triangle.

Previously the same thing with another view.

Also fetching schema takes forever and I get this information that "field list item has error"

 

Any ideas?

Thanks

mkulikowski_1-1716826292350.png

 

mkulikowski_0-1716826238191.png

 

mkulikowski_0-1716825705880.png

 

7 REPLIES 7
mkulikowski
Frequent Visitor

The message has changed now which makes more sense: 

mkulikowski_0-1718094235894.png

 

mkulikowski
Frequent Visitor

Apparently everything is working as expected, this is all by design according to Microsoft.

Error message is not an error but just information.

 

"Direct Lake semantic model process stuck: Once you add SQL views in your model, it automatically changes to Direct Query mode, since views are not supported by direct lake mode in a warehouse, leading to a Fallback, directly affecting its performance. Moreover, all Direct Query mode limitations are applied. Please refer to documentation below for a deeper understanding, as well as learning how to possibly disable such function (depending on scenario), how to analyze Dax performances, and so on."

mkulikowski
Frequent Visitor

Tables work fine. Both tables and views come from Warehouse.

Hi @mkulikowski 


Can you confirm that the column names do not have any spaces, and that the data types are supported in the delta parquet format?

 

Data types - Azure Databricks - Databricks SQL | Microsoft Learn





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

This is not the issue. Even simplest View with 1 row with integer shows errors.

Hi @mkulikowski 

 

What happens if you create a new semantic model, does it then work?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @mkulikowski 

 

Do you get the same issue if you connect to a table in direct lake view?

 

Is the source of your view a direct lake table or a warehouse table?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors