Forum Discussion

itsmebvk's avatar
itsmebvk
Continued Contributor
2 years ago
Solved

New Semantic Model Fallback Even There Is no Difference with Default Semantic Model

  Hi Folks,   I got stuck with some strange fallback issue.   I created Lakehouse with small table with two columns (City, ID). This table have only two rows     I created a new semanti...
General Comment
Need Help
Show and Tell
  • itsmebvk's avatar
    itsmebvk
    2 years ago

    tackytechtom 

     

    Ohooo I think I found the issue 🕺🕺.

     

    Looks like I missed one last suggestion by MS which might leads to Fallback if we don't follow.

     

    https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-overview

     

     

    When you create New Semantic Model, even though following option (highlighted) enabled on New Semantic Model still we need to refresh manually as highlighted. As soon as I have done that all queries turned into Dirctlakemode and no Fallback is happening.

     

     

     

     

    Before Refresh :

     

     

    After Refresh :

     

     

     

    Please correct me if I am not understanding it properly. Hope this helps someone as well. 

     

    Thanks again for your inputs.

itsmebvk's avatar
itsmebvk
Continued Contributor
2 years ago

 

Hi tackytechtom ,

 

Thanks for your quick reply.

 

To answer your observations. 

 

1) I am not using views, I am using table

 

 

2) I didn't apply security or RLS/OLS either in Lakhouse or Semantic Modle layer.

 

 

3) I have already tried DMV you have suggested but its not showing details of object which is leading to fallback however its just showing 4 as fallback reasons for new semantic model.

 

select * from $SYSTEM.TMSCHEMA_DELTA_TABLE_METADATA_STORAGES

 

Default Semantic Model (Showing 0 Fallback reasons)

 

 

New Semantic Model (Showing 4 Fallback reasons) but no additional details available 

 

 

May be I am wrong, I am assuming its highlighting following four difference which happened automatically.

 

 

 

As far as I know I strictly followed MS suggestions to avoid any fallback but still its turning into Directquery.  😞 😞 . 

 

Any other inputs ?

 

itsmebvk's avatar
itsmebvk
Continued Contributor
2 years ago

tackytechtom 

 

Ohooo I think I found the issue 🕺🕺.

 

Looks like I missed one last suggestion by MS which might leads to Fallback if we don't follow.

 

https://learn.microsoft.com/en-us/power-bi/enterprise/directlake-overview

 

 

When you create New Semantic Model, even though following option (highlighted) enabled on New Semantic Model still we need to refresh manually as highlighted. As soon as I have done that all queries turned into Dirctlakemode and no Fallback is happening.

 

 

 

 

Before Refresh :

 

 

After Refresh :

 

 

 

Please correct me if I am not understanding it properly. Hope this helps someone as well. 

 

Thanks again for your inputs.