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

Поділитися
Вставка
  • Опубліковано 1 жов 2024

КОМЕНТАРІ • 18

  • @fr1sket363
    @fr1sket363 8 місяців тому +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.

  • @tahmidyusuf6674
    @tahmidyusuf6674 4 місяці тому +1

    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
    @MithunBalamurugan 6 місяців тому +2

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

  • @Vatsav04
    @Vatsav04 Місяць тому

    Hey,
    I am unable to select columns from different tables can someone please help me wih this ?

  • @d.v.hareesh5574
    @d.v.hareesh5574 4 місяці тому +1

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

    • @Vatsav04
      @Vatsav04 Місяць тому

      Same Problem Here

  • @lauravasani1067
    @lauravasani1067 28 днів тому

    Thank you! This worked perfectly. Do you know when Microsoft started supporting field parameters in Direct Lake models? I saw in July 2024 documentation for Direct Lake that field parameters are now supported, but wasn't sure when that went into effect.

  • @akhilannan
    @akhilannan 8 місяців тому +1

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

  • @lambanlaa
    @lambanlaa 4 місяці тому

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

  • @Nalaka-Wanniarachchi
    @Nalaka-Wanniarachchi 8 місяців тому

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

  • @adamsabourin9416
    @adamsabourin9416 5 місяців тому

    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.

    • @K_dyub
      @K_dyub 4 місяці тому

      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.

    • @gFowmy
      @gFowmy Місяць тому

      @@K_dyub
      Use TE 2 the free version which allows you to connect to XMLA endpoint and save the changes back.

  • @SandeepPawar1
    @SandeepPawar1 8 місяців тому

    ❤Super

  • @mikemorrison1931
    @mikemorrison1931 8 місяців тому +1

    No, I’m trying to get you in trouble but which one of you is Pinky?
    You can tell me at the fabric conference

  • @guillermodebiase5803
    @guillermodebiase5803 8 місяців тому

    Excelent video!!!

  • @matthiask4602
    @matthiask4602 8 місяців тому

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

  • @oscarc8816
    @oscarc8816 8 місяців тому

    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?