topic How to make a field parameter inside of Lakehouse (Semantic Model) Fabric in Developer

How to make a field parameter inside of Lakehouse (Semantic Model) Fabric

fraitas — Tue, 15 Jul 2025 05:50:40 GMT

Hi everyone,

I’ve been building an end-to-end ETL pipeline in Microsoft Fabric: extracting data from our source systems, loading it into a Lakehouse, and then consuming it in Power BI.

Here’s the issue I’ve run into: when I create a Field Parameter in the Lakehouse semantic model and use it in my Power BI reports, it only returns the column name—not the values I need. However, if I build the same Field Parameter directly in Power BI Desktop (using hybrid storage), it works perfectly.

Picture 1: When I do the Field Parameter inside of Desktop.

(See picture 1): The Field Parameter returns both the column name and the expected values.

When I define the Field Parameter in the Lakehouse semantic model (see picture 2 & 3), Power BI Desktop only shows the column name, but no values.

Has anyone encountered this before, or know why the Lakehouse model behaves differently?
Any tips on how to get the full Field Parameter functionality—column names and values—when using Fabric Lakehouse would be greatly appreciated.

Picture 2: When I do the field parameter inside of the Semantic Model, from Lakehouse and then put it in Power BI Desktop

Picture 3: The Semantic Model that is made from Lakehouse, the option for Field Parameter

Thanks!

Re: How to make a field parameter inside of Lakehouse (Semantic Model) Fabric

tharunkumarRTK — Tue, 15 Jul 2025 07:01:56 GMT

@fraitas

I tried replicating your scenario, for me its working fine

1. I created a direct lake semantic model from lakehouse and created a field paramter

2. I connected to that semantic model from power bi desktop and used the filed paramter in a visual and it is showing the column name and values of the column

not sure if I missed anything, let me know if there is anything I missed. In observation is working fine

Re: How to make a field parameter inside of Lakehouse (Semantic Model) Fabric

fraitas — Wed, 16 Jul 2025 08:45:01 GMT

Thanks for answer!

For future readers, my problem seems to be that I have a mixed storage mode in my PBI and thus making the Field Parameters from Fabric Semantic Model invalid 🙂