No video :(

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

Подписаться 445 тыс.

Просмотров 8 тыс.

50% 1

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.microsof...
Direct Lake
learn.microsof...
Tabular Editor
tabulareditor....
Tabular Editor Script
github.com/tab...
📢 Become a member: guyinacu.be/me...
*******************
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/co...
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com...
#PowerBI #DirectLake #GuyInACube

Опубликовано:

15 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 14

@fr1sket363 6 месяцев назад

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.

@d.v.hareesh5574 2 месяца назад

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 3 месяца назад

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.

@MithunBalamurugan 4 месяца назад

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

@akhilannan 6 месяцев назад

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

@Nalaka-Wanniarachchi 6 месяцев назад

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

@guillermodebiase5803 6 месяцев назад

Excelent video!!!

@lambanlaa 2 месяца назад

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

@adamsabourin9416 4 месяца назад

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 3 месяца назад

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.

@oscarc8816 6 месяцев назад

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?