Can you use Field Parameters with Direct Lake in Power BI?

We got the question if you could use Field Parameters with Direct Lake in Power BI. The answer is yes? However... Patrick tells more!

Let report readers use field parameters to change visuals (preview)

Direct Lake

Tabular Editor

Tabular Editor Script


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #DirectLake #GuyInACube

[frsket]

This is great n all, but can microsoft not just add the ability to create field params in warehouses or lakehouse etc. I am currently building out a warehouse and it's the only thing i need that i can't do without creating a local model in my desktop editor. Working with external tools is not really and option for me.

[MithunBalamurugan]

Makes me wonder if the same steps can be used to create field parameters in a Live connection? 🤔

[d.v.hareesh]

Hi Patrick,

I'm unable to select columns from multiple tables in the Tabular editor even though there is a relationship between them. Do I need to turn on any settings for multiple selections. I'm using Tabular editor 2.21.1 version. Please help!!

[Nalaka-Wanniarachchi]

Nice one.Hope this "recalculate/Calculate table" in TE is similar to recalculate option in SSMS .

[lambanlaa]

I’m having this issue too. I don’t want to use 3rd party software though for business reasons.

[akhilannan]

Interesting, so the calculated table for field parameter will be in import mode and other tables in DirectLake?

[tahmidyusuf]

Hi Patrick. Thanks for the amazing workaround. There's still a problem with using tabular editor to create field parameters. that is, after I create the field parameters in this way, I can't access the "Edit Tables" option. After clicking this, it says "We couldn't fetch your warehouse schema". I could only solve this through deleting the field parameter. So until everything in the development has completed, we can't build & use field parameters in this way. Kindly let me know if you have any suggestions.

[adamsabourin]

Is this only possible with the "Enterprise Edition" of TE3? I have the Desktop Edition and nothing comes up when I open the "load semantic model" menu.

[oscarc]

I tried this method but with calculation groups instead - unfortunately I found that if the data in the lake house changes then after a while the report starts falling back to direct query 😮 has a change been made recently to stop this happening?

[matthiask]

hm... using an external code that is written in an old programming language (c#) seems like given up on security altogether :)

[mikemorrison]

No, I’m trying to get you in trouble but which one of you is Pinky?

You can tell me at the fabric conference