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
Thank you so much for mentioning about the AllowNewAPI right off the bat. Drove me nuts until I found your video. Thank you
@andrewhess123
6 күн бұрын
Woohoo! Nice Alex!
great!!!!! gracias Andrew
@andrewhess123
Ай бұрын
De Nada Draix_Bro!
Absolute gem of a video. 🎉
@andrewhess123
7 ай бұрын
Thanks Jan! Thanks for watching!
You are the man. The AllowNewAPI being set to false instead of true was driving me crazy. THANK YOU!!
@andrewhess123
4 ай бұрын
Woooo! Nice easy win! 😀
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
10 ай бұрын
Yeah it drove me crazy for a while 🤪
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
11 ай бұрын
Nice! Awesome Thanks Moe King! Hope to create many more!
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.
Thank you very much for sharing
@andrewhess123
7 ай бұрын
Thank you for watching!
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?
how can i filter using a combobox?
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
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
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
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
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
My filtering not working