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

Рет қаралды 7,947

Күн бұрын

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)
learn.microsoft.com/power-bi/...
Direct Lake
learn.microsoft.com/power-bi/...
Tabular Editor
tabulareditor.com/
Tabular Editor Script
github.com/tabulareditor/Tabu...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #DirectLake #GuyInACube

Пікірлер: 14

@fr1sket363 5 ай бұрын

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 3 ай бұрын

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

@guillermodebiase5803 5 ай бұрын

Excelent video!!!

@Nalaka-Wanniarachchi 5 ай бұрын

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

@akhilannan 5 ай бұрын

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

@d.v.hareesh5574 Ай бұрын

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!!

@tahmidyusuf6674 Ай бұрын

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.

@adamsabourin9416 3 ай бұрын

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.

@kennethwaynescott8469 Ай бұрын

Ya, I also only have the desktop and I think we're out of luck as you have to have at least the Business subscription to connect through XLMA.

@lambanlaa Ай бұрын

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

@SandeepPawar1 5 ай бұрын

❤Super

@oscarc8816 5 ай бұрын

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?