Charts! Filter Power BI through Power Apps - Challenges and Solutions!

Поделиться
HTML-код
  • Опубликовано: 18 ноя 2024

Комментарии • 37

  • @jray1429
    @jray1429 Год назад +1

    Great job Andrew…I’ve had a lot of frustration with PowerBi and PowerApps working together. Especially when it seems like it would be simple.
    Thank you for figuring it out for us. 😀

  • @andreagil852
    @andreagil852 3 месяца назад +1

    Muchísimas gracias, he logrado filtrar correctamente usando APIs . Casi me había dado por rendida hasta que encontré tu vídeo. Sigue adelante.

  • @brandinrogers280
    @brandinrogers280 8 месяцев назад +1

    You are the man. The AllowNewAPI being set to false instead of true was driving me crazy. THANK YOU!!

  • @moeking5601
    @moeking5601 Год назад +2

    Another Amazing video and at perfect timing, I'm working on a project that requires charts at first I was going to use Excel but you have shown me a whole new world Thank you, Andrew

    • @andrewhess123
      @andrewhess123  Год назад

      Nice! Awesome Thanks Moe King! Hope to create many more!

  • @AlexFergus-t7t
    @AlexFergus-t7t 4 месяца назад +1

    Thank you so much for mentioning about the AllowNewAPI right off the bat. Drove me nuts until I found your video. Thank you

    • @andrewhess123
      @andrewhess123  4 месяца назад

      Woohoo! Nice Alex!

    • @manjunathak4822
      @manjunathak4822 3 месяца назад

      same case, thanks for mentioning about AllowNewAPI

  • @boynextdoor8838
    @boynextdoor8838 2 месяца назад +1

    Thanks for sharing Andrew! Very helpful when I need solution for integrated between these two 😘

  • @janurbanek1127
    @janurbanek1127 Год назад +1

    Absolute gem of a video. 🎉

  • @KhalidWaleed59
    @KhalidWaleed59 8 месяцев назад

    Thank you for sharing this. I was going crazy as well with both the issues, first my tiles not appearing in the selection drop down and then later on with the filter URL not working. You saved a lot of my time.
    One question how to escape special characters in table/column names e.g. for space we use _x0020_ what should we use for / or @ etc.

  • @Robo_Mindz
    @Robo_Mindz 2 месяца назад +1

    Excuse me, I would like to ask you how you can make multiple filters work at the same time?I try one filter and it works, but when I try more than one it becomes a full selection and doesn't work.

    • @andrewhess123
      @andrewhess123  2 месяца назад

      你好 Zack! So yeah it was a problem for me too, but near @12:20 you can see we were multi filtering and one easy way to do it was concat on the Power BI side. Also at @8:44 we talk about using DAX. The easiest way for me was the concat way, I agree it was a little "buggy", but here is more documentation: learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

  • @jray1429
    @jray1429 Год назад +1

    This is great! I’ve tried it and it would let me filter when I was working with the tiles…but when just inserting my whole dashboard, everything in the dashboard worked. Is there a way to pass a value from the dashboard to another control in the app? Like a text field, etc

    • @andrewhess123
      @andrewhess123  Год назад +1

      Hey again Jray! So hmm.. I think you want to try in Power BI and Embedding Power Apps Integration part. This may give you more control there? Did you watch this one? ruclips.net/video/vljlO7g1COA/видео.html
      It may be possible to do what you are trying though too, but when you embed and integrate that gives you more "Power".

    • @jray1429
      @jray1429 Год назад +1

      @@andrewhess123 One odd question in my mind is…Are you able to put the PowerBi report that has an app embedded in it, in another app
      For instance, we have projects system that is built in powerapps. I want to use the advanced search and reporting capabilities of powerbi. So, I embed a small powerapp in that super zoomy powerbi report that I just made for searches and reports. Could I embed that powerbi report in the actual projects system app❓ What would be the purpose of this? Good question…One of the things we don’t want to do is have the users go to multiple apps. I don’t know I’d do it and it may take too much overhead for it to be efficient, but it’d be interesting to try it out
      By the way, thanks for sending me to that other video. I know, that might be a weird question. 🤓

    • @andrewhess123
      @andrewhess123  Год назад

      Ha! Good question, I guess it could be possible? It is not something I have tried yet. But now that you got me thinking, now I want to try 😃@@jray1429

  • @aducaale328
    @aducaale328 3 месяца назад +1

    Thanks for this great content

  • @JenMayB
    @JenMayB 9 месяцев назад

    Thank you - very helpful! I need to filter on email claim of person field in a sharepoint list - where the user might be in multiple fields of the spo list - so i need and ‘or’ not an and/concat?

  • @PotatoBrosGames
    @PotatoBrosGames 5 месяцев назад +1

    great!!!!! gracias Andrew

  • @giaitrivietnam3415
    @giaitrivietnam3415 11 месяцев назад +1

    Thank you very much for sharing

  • @SaisirishaMundra
    @SaisirishaMundra 10 месяцев назад

    For Tile filter it's working... coming to the embed report the filter is not working I set the allow api also true but filtering is not working could please assist me how to resolve this

  • @manjunathak4822
    @manjunathak4822 3 месяца назад +1

    Hi Andrew...i have embedded a power bi report in powerapps, now added this app as tab in teams, now if i am trying to access the app, am unable to login to the bi report in powerapps, however in powerapps environment am able to login and get data, but am trying from teams am unable to login to bi report,it asking to sign in , when i click on sign in it loads a white page , unable to login, note i have proper permissions for both app and report, any suggestion. many thanks in adavnce.

    • @andrewhess123
      @andrewhess123  3 месяца назад

      Hi MANJUNATHA K, my guess is the issue is on the Power BI report/dashboard side of things. If you can get into the app, if you can get into the MS Team, it has to be on the Power BI side? I would also try in MS Teams in browser and in the actual client. Maybe there is an issue in the passing in the client version of Teams? Does the browser version of MS Teams work?

    • @manjunathak4822
      @manjunathak4822 3 месяца назад +1

      @@andrewhess123 yes in the browser version of teams it's working fine, however in teams app it's not working.

    • @andrewhess123
      @andrewhess123  3 месяца назад

      @@manjunathak4822 Then there is some issue in the MS Teams client. Maybe how credentials are passed. It may even only be an issue for your PC?

    • @manjunathak4822
      @manjunathak4822 3 месяца назад

      @@andrewhess123 I have checked with my team it's not about my pc, my team also unable access the power bi. Report from teams apps.

  • @dhanushreddy2894
    @dhanushreddy2894 7 месяцев назад

    how can i filter using a combobox?

  • @NetworkMining-n7u
    @NetworkMining-n7u 10 месяцев назад

    My filtering not working