Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I'm using Tabular 15.0.32.50 and in my Tabular Model there are measures that use FirstNonBlankValue and LastNonBlankValue expressions. However, I get this error when I try to add a measure to a Power BI report connected to this model via SQL Server Analysis Service.
From what I found, these expressions were released back in 2019. Can I know what version this syntax is supported in?
Solved! Go to Solution.
Hi @asirieka ,
According to the error message displayed in the screenshot, it seems that Power BI doesn’t recognize the function FirstNonBlankValue and LastNonBlankValue. The following official documentations referred the info below:
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
FIRSTNONBLANKVALUE function (DAX) - DAX | Microsoft Learn
LASTNONBLANKVALUE function (DAX) - DAX | Microsoft Learn
You can consider upgrading to a newer version of Analysis Services. Alternatively, you may need to find a different way to achieve the same result using other functions that are supported in your current version of Analysis Services.
Best Regards
Thank you, this was helpful😊
Hi @asirieka ,
According to the error message displayed in the screenshot, it seems that Power BI doesn’t recognize the function FirstNonBlankValue and LastNonBlankValue. The following official documentations referred the info below:
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
FIRSTNONBLANKVALUE function (DAX) - DAX | Microsoft Learn
LASTNONBLANKVALUE function (DAX) - DAX | Microsoft Learn
You can consider upgrading to a newer version of Analysis Services. Alternatively, you may need to find a different way to achieve the same result using other functions that are supported in your current version of Analysis Services.
Best Regards