PowerApps Power BI Integration Dynamic Filtering

[@jessicarodrigues9539]

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"

[@ShanesCows]

Yup Jessica. Thanks for posting. They added the setting after I made the video 😔

[@fscohen]

@@ShanesCows this solved my issue!!! Thanks a lot!

[@rishabhkhanna703]

Hi Shane, after enabling AllowNewAPI it somehow does not work for me and always asks to signin to the power tile. Can you please assist?

[@DylSimons]

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

[@ShanesCows]

Interesting Dylan. I will have to check that out. A few people have asked in the comments, you might share the insight with them. 😀

[@CristianLopez-ym5oc]

thanks!!!!!!!!!!!!!!!!!!!!!!!!!!

[@MicahandModesta]

I can confirm that this fixed my first issue (where it didn't update after adding the parameter)

[@moritz5459]

This should be the top comment. Took me hours to figure that out. "AllowNewAPI" has to be set to true in order for any of that to work.

[@dkilps]

Legend for figuring this one out!

[@pedroeaugusto]

As we say in Brazil, "You are BRABO"! (Like you are the best, but cooler). Thank you so much Shane for all the lessons you give us!

[@ShanesCows]

Thank you! 😊

[@robertmerritt5245]

Awesome, as usual Shane! Suggest increasing size of button, making it transparent and layering it over the PowerBI control.

[@ShanesCows]

Cool idea Robert! I like that a lot. 😎

[@sudhamshkadudas1064]

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 ?

[@sudhamshkadudas1064]

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.

[@ShanesCows]

Glad you got it 😀

[@kimgaskins5537]

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?

[@DataSpinners]

Great vid Shane - it's soo important to use these techniques to pull together the Power Platform!

[@ShanesCows]

I agree. 😀 Thanks Rory I hope everyone checks out your great content also.

[@DataSpinners]

@@ShanesCows Thanks Shane - just doing my bit for the cause!

[@nathanface8225]

Yes, yes, yes! I was just trying to figure out how to do this yesterday!!! Thank you!

[@ShanesCows]

Happy to help!

[@queren7806]

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!

[@ShanesCows]

Yes. 😔

[@queren7806]

@@ShanesCows Thanks very much Shane! Another question is there a way to disable the redirection from Power BI tile to Power BI website?

[@guillermoaristizabalrestre2948]

Better than perfect!!! Shane a silly question: It is possible filter the data with the online user email or name?

[@ShanesCows]

Yes. Use the User() function to get the logged in users info.

[@benaima]

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!

[@ShanesCows]

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.

[@AndreasMake]

You have a great day too for sharing. Thanks Shane for your awesome videos.

[@ShanesCows]

Thanks!

[@gemmaparker82]

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!

[@ShanesCows]

Hey Gemma I am not sure, I haven’t ran into that. I would try a ‘ around the name but not sure.

[@AndreasMake]

Does this method support all or most visuals? Dont see the filter pane options on my dahsboard. Thanks for sharing Shane.

[@ShanesCows]

I think so but I am not super good at PBI so I could be wrong.

[@luisriveroblanco-uribe5165]

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?

[@ShanesCows]

Hey Luis I have not tried multiple so I am no help. Sorry

[@luisriveroblanco-uribe5165]

@@ShanesCows thanks! For answering!

[@yakirrabinue3889]

@@luisriveroblanco-uribe5165 Hi, now I'm handling the same issue... I think multiple filter's parameters may not work... did you mange to solve it?

[@giorgitsomaia2812]

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

[@anirudsaichenna3158]

@@giorgitsomaia2812 Hi, Any solution on this, I am also looking for this appreciate if someone can help on multiple filtering if any on did that

[@giannibergamo9703]

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.

[@ShanesCows]

Sorry I am not awesome at PBI troubleshooting

[@jakobooms161]

Check the ‘AllowNewAPI’ in the advanced tab of the tile in power apps is set to true

[@laurah1990]

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!

[@derek_shannon]

"Just try things" -- Very good advice, Shane! ;-D

[@ShanesCows]

Thanks. I wish more people would follow it. 😻

[@alexchase2983]

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?

[@ShanesCows]

Dataset it think

[@DarrynPinto]

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?

[@zylka172]

Shane, you're brilliant!

[@ShanesCows]

Thanks

[@mardithpascua8112]

HI Shane, is it possible to have for example a Gallery Tab in powerapps then when click the PowerBI report will show a respective Tab?

[@orbivictting5470]

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.

[@ShanesCows]

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.

[@devyanisingh2303]

I had one question, can I choose two values for a single selected filter on the Power Apps to filter the Power BI Tile? Or is that not possible?

[@ShanesCows]

I am not sure. Try an And and see what happens. Sorry, I don’t know

[@anandasanyal]

Hi, Thank you for your session. Can we force the report Launch in Focus Mode? Any idea? Thank you

[@ShanesCows]

Not that i know of 😑

[@seyiogunniran6370]

Fantastic, how can I use multiple filter on the tile url.

[@ShanesCows]

You would have to look at PBI to see if that is possible or not b

[@sw97058]

Good video, but how do I do this the other way around? I have a powerBI report and I want to send the filters from that into my app.

[@ShanesCows]

So I haven't done in years but it is possible to embed a Power Apps app inside of your PBI report. This old video should at least get you close kzbin.info/www/bejne/fmrciq2GnJV_ra8

[@sw97058]

@@ShanesCows Wow, thank you for the response within the same business day! I already had my app setup within a powerBI drilldown, but I didn't know how to filter the app based on the fields I was passing through PowerBI. I eventually got it by setting my gallery Items = 'PowerBIIntegration'.Data and then doing a lookup from that to my sharepoint list in the form Items. It is confusing because PowerBIIntegration doesn't show up as a data source in the dropdown menu.

[@transvalteollisuuspalvelut7055]

Hi Shane, I tried using these instructions but for me it seems this method doesn't work currently at power apps side?

[@ShanesCows]

Have you tested in the browser with Powerapps. Power apps isn’t the problem it is getting the url filter right. Good luck

[@MicahandModesta]

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.

[@MicahandModesta]

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

[@ShanesCows]

Glad you got it working and thanks for sharing with everyone how. 👍

[@danilom8893]

You rock dude! You’re the best! Thanks for make my corporate life better! Greetings from Brazil

[@ShanesCows]

Thank you

[@LuxiaShen]

Hi Shane, what should the "Slider1.Value" part be for a text input filter? Thanks!

[@ShanesCows]

TextInput1.Text I think is the answer to your question.

[@LuxiaShen]

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

[@periclessyntakis1805]

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

[@siddharthgoutam6342]

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]

For the Power BI Tile did you set the property AllowNewAPI to true. That might help?

[@siddharthgoutam6342]

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

[@peterhelms-nielsen8838]

Instead of the button, could you use the OnSelect option on the tile?

[@ShanesCows]

Probably. I should have tried that. 😀

[@adityaprakash9151]

Hi sir can you please tell how we can use “in” instead of eq operator to filter even for conacanted data

[@ShanesCows]

I am not sure, I haven't tried that one.

[@fscohen]

Hi Shane, Is there any way to apply a filter to the tile with a "contains" condition instead of equal (eq) operator?

[@ShanesCows]

I haven't tried. I did some quick searching and I don't see an answer here :( Not saying it isn't possible, but if it is, I don't know how. 😐

[@fscohen]

@@ShanesCows thanks for the quick reply. In case tou find a solution or you have any workaround idea please let me know. Thanks

[@itXpert1]

This is just what I needed. Great video! Great teacher! Thank you.

[@ShanesCows]

Glad it was helpful!

[@KI_Burgberg_DE]

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

[@ShanesCows]

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.

[@KI_Burgberg_DE]

@@ShanesCows thanks for your answer. It was really helpful. Have a good year 2022. :-)

[@aartisingh987]

@@ShanesCows Thanks a ton!

[@eurekasheng542]

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

[@ShanesCows]

Yeah, PBI Licensing is enforced even via Power Apps :(

[@MrSwaroopvadde]

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.

[@ShanesCows]

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.

[@jyothisrinivas6637]

Excellent Shane.. you are rocking

[@ShanesCows]

😻 thanks

[@garisoncyr6696]

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?

[@torresbryan]

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?

[@ShanesCows]

Sorry haven’t worked with on-prem PBI so not sure. Spaces in the name will probably be a problem also.

[@matthewvandersteen7738]

Thanks Shane! This helped me a lot! Keep up the good work.

[@ShanesCows]

Happy to help 🐶

[@bryancampos7607]

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!

[@ShanesCows]

I haven’t tried. Sorry Bryan. 😑 If you figure it out please share.

[@bryangutierrez4787]

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

[@maryemlakbir9173]

How come this is not working for me at all, has there been an update in Power Apps / Power BI since 2019 ?

[@ShanesCows]

There is a new property for the control AllowNewAPI set it to true and things should work as in the video.

[@bhaskarmandal243]

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?

[@ShanesCows]

Sorry not sure. I would think so but I have never tried.

[@alexgosser5587]

Hi Shane! I had a quick question for you - is it possible to tell if the power-bi has refreshed recently and/or if the filters display no data?

[@ShanesCows]

... not that I know of but I have never tried.

[@venkik8605]

@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

[@ShanesCows]

Sorry not sure.

[@youngdataio]

Same issue

[@edgarlpsoldier]

How can I filter a Date range? simulating the slider control from powerbi in powerapp for a Dynamic graph

[@ShanesCows]

I have not tried. Sorry Edgar

[@edgarlpsoldier]

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

[@cristianlipski3730]

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?

[@DylSimons]

This just happened to me today on Power App release version 3.21071.26

[@cristianlipski3730]

@@DylSimons put an espace after the first double quot in tile ulr

[@DylSimons]

@@cristianlipski3730 could you give an example? how would you change this simple fitler in the TileURL? "apps.powerapps......" & "&filter=Table/Field eq 'row'"

[@cristianlipski3730]

@@DylSimons "(put an space)(powerbi report adress...)

[@cristianlipski3730]

@@DylSimons let me know if it works..

[@terrisepulveda627]

I literally cried when I seen this totally awesome stuff!!!!!!!!!!!!

[@ShanesCows]

Awesome 😎

[@mrstevennewmanEDU]

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)

[@DylSimons]

This just happened to me today on Power App release version 3.21071.26

[@DylSimons]

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

[@benjamincpetersen]

@@DylSimons THANK YOU SO MUCH! I could not get this to work and this was why!!

[@garaymr]

Thank you!

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@MwMproduktion]

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!

[@garisoncyr6696]

Change "DisplayMode" property on the tile from "Edit" to "View" should take care of it!

[@apostolosstamatopoulos9033]

Hi Shane, have you made any videos about timestamps?

[@ShanesCows]

A little bit. Look for audit log video

[@apostolosstamatopoulos9033]

Thanks!! It solved my issues!!

[@josephdsilva4941]

Great & very helpful.. thanks

[@ShanesCows]

Most welcome!

[@udaracperera]

This is awsome shane thank you very much for the soultion

[@ShanesCows]

Glad to help. 😀

[@mohammadmattar1561]

Hey Shane, will you show how we can use JavaScript with PowerApps

[@ShanesCows]

I don’t think you can. 😑

[@CristianLopez-ym5oc]

Impresionante!

[@ShanesCows]

😎

[@tiranirani6501]

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]

In the video I show it. YOu have to manually update the TileUrl field with your filter.

[@jean-philippedelaune2607]

It’s so wonderful ! Thanks !

[@ShanesCows]

Happy to help 😎

[@leehyunjin3745]

how to set datepicker in power apps url to filter data by date

[@pierre-emmanueldrouart9328]

Exactly What i was looking for ;-) thank a lot.I try to do the same but it doesn't work right now;-) play again ;-)

[@ShanesCows]

You will get it. 😀

[@sokgat7019]

Wow!!! Thanks Shane!!!

[@ShanesCows]

Glad to help. 😀

[@yoismelperez2744]

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'

[@PareshMhetre]

awesome! thanks

[@ShanesCows]

Glad to help. 😀

[@sagaisaac]

can you explain in a video how its work PowerApps Plan 2? and how its posible that a user guest can use una App.? :)

[@ShanesCows]

I haven’t covered guest access yet. I will add it to the list.

[@martingervasoni6939]

Genio

[@itXpert1]

You need set "AllowNewAPI" (you find it in PowerBI tile properties) to TRUE otherwise the filtering will not work, the rest is exactly as the video.

[@ShanesCows]

Thanks for sharing! 😍

[@imadlodhi4616]

nice!! that tan though :P

[@ShanesCows]

Rest of me is pale white. 👻

[@eurekasheng542]

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;

[@franknielsen3219]

Aweeesooooommmeeeeeeeeee!!! :)

[@ShanesCows]

Thank you 🙏

[@craigschulz948]

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?

[@ShanesCows]

I don't Craig. Sorry. I haven't had that issue.

[@GusFloras]

what if I have after report section numbers and letters such e.g : ReportSection053bed5a276abc5d2c4e ? filter=asp_ebs_sellers eq %271212%27 ???

[@GusFloras]

Do I need to remove them and play as you show us? or to leave them as is and to add ? filter ?

[@ShanesCows]

Not sure. You will just have to try some different things.

[@khargos7602]

Omg query strings and operators! I am become nerd.

[@ShanesCows]

you are going to know more than I do before long Khar! 🐶

[@khargos7602]

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

[@vinodvinu5895]

Hi Shane

[@vinodvinu5895]

I have one report I am fetching data from sql to powerbi report same report I need to intigrate powerapps dynamically it's not working

[@rodrigopresencebagarolo2892]

hahahaha nice video!

[@ShanesCows]

Thanks 😊

[@vinodvinu5895]

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