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

Ғылым және технология

Running into issues filtering Power BI tiles through Power Apps? Well I had a few. In this video we go over not just how to add Power BI tile, but also every issue I ran into trying to filter. I do believe watching this video is going to save you time with all those small issues most Power Apps and Power BI developers may run into embedding a Chart into Power Apps.
Come check it out!
My name is Andrew Hess, please like & subscribe!
Chapters
0:00 Introduction
1:10 Filtering Not Working? AllowNewAPI
3:00 Power BI Tile not Selectable in Power Apps? Rename Tile
5:40 Filtering Power BI through URL
7:20 Space in Columns or Titles use x0020
8:15 Multifiltering BI in Power Apps? Use Concat with DAX
12:30 Display Full Dashboard in Power Apps
14:55 Filtering Power BI using "in"
17:50 Filtering Based on a Gallery

Пікірлер: 23

  • @AlexFergus-t7t
    @AlexFergus-t7t6 күн бұрын

    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

    6 күн бұрын

    Woohoo! Nice Alex!

  • @PotatoBrosGames
    @PotatoBrosGamesАй бұрын

    great!!!!! gracias Andrew

  • @andrewhess123

    @andrewhess123

    Ай бұрын

    De Nada Draix_Bro!

  • @janurbanek1127
    @janurbanek11277 ай бұрын

    Absolute gem of a video. 🎉

  • @andrewhess123

    @andrewhess123

    7 ай бұрын

    Thanks Jan! Thanks for watching!

  • @brandinrogers280
    @brandinrogers2804 ай бұрын

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

  • @andrewhess123

    @andrewhess123

    4 ай бұрын

    Woooo! Nice easy win! 😀

  • @jray1429
    @jray142910 ай бұрын

    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. 😀

  • @andrewhess123

    @andrewhess123

    10 ай бұрын

    Yeah it drove me crazy for a while 🤪

  • @moeking5601
    @moeking560111 ай бұрын

    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

    11 ай бұрын

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

  • @KhalidWaleed59
    @KhalidWaleed593 ай бұрын

    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.

  • @giaitrivietnam3415
    @giaitrivietnam34157 ай бұрын

    Thank you very much for sharing

  • @andrewhess123

    @andrewhess123

    7 ай бұрын

    Thank you for watching!

  • @JenMayB
    @JenMayB5 ай бұрын

    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?

  • @dhanushreddy2894
    @dhanushreddy28943 ай бұрын

    how can i filter using a combobox?

  • @user-hi8nn9os5n
    @user-hi8nn9os5n5 ай бұрын

    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

  • @jray1429
    @jray142910 ай бұрын

    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

    10 ай бұрын

    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? kzread.info/dash/bejne/qKCezrFwl5Spf6Q.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

    10 ай бұрын

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

    10 ай бұрын

    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

  • @user-oy7zr6of2x
    @user-oy7zr6of2x6 ай бұрын

    My filtering not working

Келесі