For who are using the "pin" to create various Tiles doesnt work if you just change the URL. Theres a option in the PowerApps BI Tile named "AllowNewAPI", set to TRUE and worked fine for me"
Hi Shane, PowerBI controls in Power Apps now have a new property "AllowNewAPI", set that to true and it works as expected. It defaults to false, which turns this dynamic filtering feature off
Hi Shane, great video! In my case I only managed to make the button work. I don't know why filters doesn't work with the tile... The query string is correct: parameter filter and values are the same that works with the button. The visual is correctly pinned, not a live page.
Thanks so much! Love this and can use it when my data source doesn't have spaces, but when my table and columns have spaces in them, how can I manage this in the TitleURL? Thanks!
Great as usual Shane and as usual, I have a slightly different request... We've passed text to BI from PowerApps but we are having a time filtering on a date value (not dateTime); any suggestions?
As always, that was really helpful Shane. The filtering works perfectly fine on the report, but when I try to filter it on the PowerApp, it doesn't seem to work. I am using the following query &filter=Submissions/FY eq 'FY17/18'. I am pretty sure I have not missed any of your steps having gone through the video multiple times. Are we no longer able to filter through querystring on dashboard? Has anything changed with PowerApps or PowerBI ?
Found out what the issue was: I was selecting the dashboard which I had created by selecting 'Pin a live page'. I guess the filtering only works when you select 'Pin visual' for individual tiles and not the whole dashboard.
Hi Shane, thanks again for your help. Can I use dynamic filtering to match one of the power bi tile fields with the user logged in my powerapp? I tried the User().email function but could not make it work. Thanks in advance for the reply!
Yes, should be possible. Maybe try storing the useremail in a variable on app start then use that variable. I would test with just a hard coded email and then go from there.
Hi Shane, thank you so much for this video. One question - whenever i embed a power bi tile in powerapps, while in Power Apps (for all users), befoe the tile displays, it asks the used to sign-in to powerbi almost all the time. It's the same microsoft user ID for both. Is there a way to avoid this from happening?
Hello, would there be a way so that when you select a gallery item that is linked to a sharepoint list a different Power BI tile appears? As in load a different dashboard tile
Hi Shane, once again I struck at some point and your videos are life saver but i am getting an error when trying to apply the filter ?filter=Table_x0020_Name/countryName eq 'UK' . Here UK is a lookup column, The error i am getting is "this filter cant be used since the corresponding field is invalid"
@@ShanesCows yes shane i already checked that the issue comes only for lookup fields, other fields work perfectly fine. The doubt I have is that for lookup fields you have to paas its value as its a record type field which holds id+value.
@@ShanesCows Thanks for replying! I need to set up multiple filters in my report. When a search value is not provided for a filter, the search value that got passed on to Power BI is empty which returns no result (filter1 is xxx and filter2 is empty). I'm trying to get the report to do is filter1 is xxx and filter2 is select all. Do you happen to know what I need to do to get the report to do that? Thanks again!
Thanks Shane, love it. My only little issue is that when I embed the link, I end up with the page number showing at the bottom (e.g. 'Page 1') whereas you've just got the single graph (which ideally I'd want). How does one fix this so they can only see the graph? FYI anyone who can see the 'filter' pane, go into Desktop, click the 'eye' next to the filter pane, then re-publish, this needs to be hidden from the report.
FOLLOW UP - fix to my top issue is to add this at the end of the URL: &navContentPaneEnabled=false Make sure also to have AllowNewAPI (under advanced settings) as true, solution offered earlier Dylan Simons
Hi Shane, this video is very helpful. Thanks very much for making these great PowerApps videos. A quick question, if we use Power BI tiles in PowerApps, do we still need a Power BI Pro license? Thanks!
Hi, one question, do I have to have premium license so user can view the tile without any extra access required? Currently I published a dashboard with pro license and insert into power apps, yet user without bi license couldn't view it at all
This is a really interesting feature. I am just struggling with the Power Apps filter. It does not work. On the Power BI side it work on the URL. I use a direct query to Azure SQL. I followed any step on your video. I have no idea what kind of special thing is stopping me. Wished I could receive little help in the big cosmos. greets from Germany, Klau
Since this video was made, they changed a property “AllowNewAPI” on the tile control in Power Apps to be false by default. Change it to true and you can filter your tiles.
Hi Shane, thanks for the great video! Question, would it be possible to filter by the id of a lookup field? f.e. if I want to filter based on a related account, I managed to filter by the account name ( using prefix_customtable/Account eq 'Name of Account') but this value is not necessarly unique, is there a way to set up the url parameter to use the (unique) id of the Account? Thanks again for that great content, it's greatly helping me along my dynamics journey!
@@ShanesCows I got to filter by date as i want it in URL but i can't reply it to the URLTiltle instruction in powerapps, in URL the command is ?filter=Table/Date gt 2019-05-20 as example, but in powerapps i dont know how to specify, i tried with &filter=Table/Date gt '2019-05-20' " but is not filtering.
Hi Shane, Yet again another incredibly helpful video, thank you for making such excellent content. I was wondering if you had any experience in "validating" data. For example my app has a datatable in showing a bunch of monthly observations. But if a user tries to add a new observation for a date that already has one, the app informs the user this already exists and advises them to go edit the existing record. In my case this data source is from SQL server and I am using a stored proc (thanks to your help) to write new records through a gateway.
I would do a lookup for the existing record when they submit. If the LookUp comes back empty then create the new record. If it comes back as found then redirect them.
Hi Shane, what do you mean by Data Source? Ive got a series of power BI visuals already in reports and I would like to do exactly what you have done in this video, although im not sure how to find the "Data source" for the visual. In your case it was "Orders" is it simply the report name? or the tile name? or the dataset?
Hi Shane! Thanks for this video, it was really helpfull! I was wondering how to improve the dynamic filtering by applying multiple filters from selected galleries/buttons in power apps (filter City and Product Type for example)? I made some research in PowerBI blogs and it can be done by using the condition "AND" (i.e: ?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct') but i cannot manage to get a succesful result in PowerApps... Do you know any solution to implement multiple filters in PowerApps?
@@yakirrabinue3889 I tried to solve multiple filter in single column (eg. City -A and City - B), in url it goes with "in ('City - A','City - B') but could not make it work in Power APPs :((
@shane - I am going through this - have a issue where i pinned a visual and i can make the filter work in the powerbi report , but when it gets to powerapp the URL filter doesn't work and its yielding the same results
Dear Shane (or community). Anyway to remove the hyperlink of the tile in the app while keeping the tile itself? When I open the app on my phone and click the tiles it automatically throws me out of the app into the browser to the actualy dashboard. Any way to STAY in the app when the tiles is clicked? Thanks a lot!
Hello Shane / community. Is this feature still functional? In my tests, the URL filtering works for the report directly, but appending the same filter string over to the PowerApp does not work (using ampersand instead of question mark) :/ For reference, enabling the "AllowNewAPI" property does not fix this. Does it matter that I am using an excel data source?
Thanks for video Shane! Will the same approach work for Oracle database as the data source? I can filter the power bi report through URl but the power bi tile in power apps turns blank when I try to filter the URL. Any suggestions are much appreciated.
I haven’t tried but I think so. Maybe try to work on getting the url right in the browser first. See if you can find the syntax without PowerApps in the the mix.
Hey Shane, thanking you for sharing. I try to open the URL link for the visual but it takes forever to load (my power BI system is through a company license). What do i do? Also what if i have a visual that in the report is filtered already by a splicer? Will that affect it? and lastly, my sharepoint list and columns have spaces in their names. will that impact this?
Guys, I come back here to remind you ,if you use BI tile in power apps, don't use"?filter=...." to start your query. there already is a "?" in the url,so just use"&filter=......" ;I've been stuck this all night;
Hi Shane! How can i integrate multiple filters in the PowerApps URL? I need to filter by group, site and period. (3 filters), when i do it with "and" syntax in PowerBI it works but i dont know how to in PowerApps. Awesome video!
Hello you could try adding a DAX column in your dataset group&site&period and name it for instance "ConcatIndex", then in Powerapps you apply &filter=DataSet/ConcatIndex = group&site&period (the PA controllers). I think this could work
Can anybody help with this? I created a report and pinned a visual to a Dashboard which I am using to show data in a PowerApps. I tested in the report by concatenating the following filters shown below and it worked. When I append the same filters to the TileUrl in PowerApps, it doesn't work, but if I do only one of the two filters at a time, then it works. Seems I cannot get the two filters to work at a time. filter=ContractEntry/EffectiveDateNumber eq '20210518' and ContractEntry/IRHedgeITEMNumber eq 'OAK6055300'
Shane, have you had any reports of problems with the Dynamic Filters from Power App to Reports in Powerbi. Until yesterday it worked fine under the format: "urlreport & filter = Table / field eq ´Text´" but suddenly it no longer works. any ideas?
@@cristianlipski3730 could you give an example? how would you change this simple fitler in the TileURL? "apps.powerapps......" & "&filter=Table/Field eq 'row'"
Hey @Shane Young, great vid like usual. Just wondering if you or anyone knows if this works anymore? I can get the ODATA query happening on PowerBI online just like you demonstrated, but as soon as I try it on PowerApps it does not update like it does for you on this video. I even paste the filter part directly from PowerBI where it works, but PowerApps, nada. I thought I found something online that mentioned that MS disabled this feature becasue of Dataverse, but can not for the life of me find that article anymore. Microsoft's info around Power platform and what you can do with various subscriptions is very muddy OR my Google Fu is letting me down. I am working within a Microsoft 365 A3 for faculty tenant and we have a Power BI Pro for faculty subscription (Education)
Hello, this my be the issue you are facing - PowerBI controls in Power Apps now have a new property "AllowNewAPI", set that to true and it works as expected. It defaults to false, which turns this dynamic filtering feature off
Hi Shane, thank you for sharing this video, really helpful. Is it possible to apply the filter to PowerBi based on names, e.g. text based search based on a customer name, gallery.lastname.select is found in the customer names on PowerBI report?
Great video as usual Shane but am I missing something? It appears that Power BI does not support passing filters to a dashboard! This feature idea was declined by Microsoft way back (ideas.powerbi.com/ideas/idea/?ideaid=93bad850-494e-4e0e-878a-1c8348863b1c). In your video are you showing a report (looks like it) or a dashboard being filtered? When adding a Power BI Tile in Power Apps the only option is to select a Workspace / Dashboard / Tile. I can get the URL filtering working on a report by testing against the Power BI service manually but not to a dashboard. Could you clarify what you demonstrated please? Thanks
@@ShanesCows That's genuinely encouraging! I've been hittin' the vids pretty hard lately, and the sentiment you shared here is refreshing to hear. I've got a looong way to go, but I'll do my best! 😁
I have embedded a PowerBI dashboard tile into a PowerAPP and enabled interactions. However, when I click on the tile in the Power App it launches PowerBI but gives a blank canvas, not the report it should open. Here is are the first parts of the two different URLs: This is what is opened by clicking the tile in the App app.powerbi.com/reports/133693d1-39d---- This is what is opened by going directly to the report in PowerBI app.powerbi.com/groups/74b78c03-c163-446d-8926-d51e2fffb7c5/reports/133693d ----- Any idea how to make the interaction work properly?
Hi Shane actually i am fetching data from Sql DB but unable to filter multiple condition. LookUp('ref.dashboard_power_bi_mapping',asset_class_id=Gblassetclassidselectedd&&site_id=Gblsiteidselected&&power_bi_report_type_id=2,power_bi_report_url)&"&filter=Site/SiteName eq '"& Gblsiteselected & "'" &" and Asset/AssetName eq '"& GlrybyAssetsunderrespectiveFleet.Selected.asset_name &"'" can you please help me out