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

4 ай бұрын

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?

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

@ShanesCows

4 жыл бұрын

Thanks!

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

11 ай бұрын

Thank you! 😊

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

@ShanesCows

4 жыл бұрын

Thank you

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

@ShanesCows

4 жыл бұрын

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

@DataSpinners

4 жыл бұрын

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

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

@ShanesCows

3 жыл бұрын

Glad it was helpful!

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

@ShanesCows

8 ай бұрын

Happy to help!

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

@ShanesCows

3 жыл бұрын

Happy to help 🐶

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

@ShanesCows

4 жыл бұрын

Thanks. I wish more people would follow it. 😻

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

@ShanesCows

4 жыл бұрын

Cool idea Robert! I like that a lot. 😎

Shane, you're brilliant!

@ShanesCows

3 жыл бұрын

Thanks

It’s so wonderful ! Thanks !

@ShanesCows

4 жыл бұрын

Happy to help 😎

This is awsome shane thank you very much for the soultion

@ShanesCows

4 жыл бұрын

Glad to help. 😀

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

@ShanesCows

4 жыл бұрын

Awesome 😎

Excellent Shane.. you are rocking

@ShanesCows

4 жыл бұрын

😻 thanks

Wow!!! Thanks Shane!!!

@ShanesCows

4 жыл бұрын

Glad to help. 😀

Great & very helpful.. thanks

@ShanesCows

3 жыл бұрын

Most welcome!

Thank you!

@ShanesCows

Жыл бұрын

Happy to help. Have a great day. 🐶

awesome! thanks

@ShanesCows

4 жыл бұрын

Glad to help. 😀

Impresionante!

@ShanesCows

3 жыл бұрын

😎

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

3 жыл бұрын

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

3 жыл бұрын

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

@MicahandModesta

2 жыл бұрын

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

@moritz5459

2 жыл бұрын

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

2 жыл бұрын

Legend for figuring this one out!

Aweeesooooommmeeeeeeeeee!!! :)

@ShanesCows

4 жыл бұрын

Thank you 🙏

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!

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

4 жыл бұрын

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.

nice!! that tan though :P

@ShanesCows

4 жыл бұрын

Rest of me is pale white. 👻

Genio

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

4 жыл бұрын

You will get it. 😀

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

4 жыл бұрын

Sorry I am not awesome at PBI troubleshooting

@jakobooms161

2 жыл бұрын

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

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

4 жыл бұрын

Yes. 😔

@queren7806

4 жыл бұрын

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

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

@ShanesCows

4 жыл бұрын

Not that i know of 😑

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

4 жыл бұрын

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

4 жыл бұрын

Glad you got it 😀

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?

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

3 жыл бұрын

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.

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

4 жыл бұрын

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.

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?

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

@ShanesCows

4 жыл бұрын

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

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

4 жыл бұрын

Dataset it think

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

4 жыл бұрын

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

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.

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?

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?

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

2 жыл бұрын

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

2 жыл бұрын

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

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

@ShanesCows

4 жыл бұрын

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

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

3 жыл бұрын

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

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

4 жыл бұрын

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

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

4 жыл бұрын

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

@luisriveroblanco-uribe5165

4 жыл бұрын

@@ShanesCows thanks! For answering!

@yakirrabinue3889

3 жыл бұрын

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

2 жыл бұрын

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

2 жыл бұрын

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

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!

@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

3 жыл бұрын

Sorry not sure.

@youngdataio

3 жыл бұрын

Same issue

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

@ShanesCows

4 жыл бұрын

Probably. I should have tried that. 😀

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

@ShanesCows

4 жыл бұрын

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

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

@ShanesCows

3 жыл бұрын

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

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

2 жыл бұрын

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

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

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

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

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!

@ShanesCows

4 жыл бұрын

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

@bryangutierrez4787

4 жыл бұрын

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

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

2 жыл бұрын

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

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

@ShanesCows

5 ай бұрын

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

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

3 жыл бұрын

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

@DylSimons

3 жыл бұрын

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

2 жыл бұрын

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

Hi Shane, have you made any videos about timestamps?

@ShanesCows

4 жыл бұрын

A little bit. Look for audit log video

@apostolosstamatopoulos9033

4 жыл бұрын

Thanks!! It solved my issues!!

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

11 ай бұрын

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

@siddharthgoutam6342

11 ай бұрын

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

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'

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

@ShanesCows

4 жыл бұрын

I don’t think you can. 😑

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

@ShanesCows

3 жыл бұрын

I have not tried. Sorry Edgar

@edgarlpsoldier

3 жыл бұрын

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

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

2 жыл бұрын

Thanks for sharing! 😍

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

3 жыл бұрын

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

@cristianlipski3730

3 жыл бұрын

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

@DylSimons

3 жыл бұрын

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

@cristianlipski3730

3 жыл бұрын

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

@cristianlipski3730

3 жыл бұрын

@@DylSimons let me know if it works..

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

2 жыл бұрын

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

2 жыл бұрын

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

@aartisingh987

2 жыл бұрын

@@ShanesCows Thanks a ton!

hahahaha nice video!

@ShanesCows

4 жыл бұрын

Thanks 😊

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.

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

3 жыл бұрын

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

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

4 жыл бұрын

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

Omg query strings and operators! I am become nerd.

@ShanesCows

2 жыл бұрын

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

@khargos7602

2 жыл бұрын

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

Hi Shane

@vinodvinu5895

2 жыл бұрын

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

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

@GusFloras

4 жыл бұрын

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

@ShanesCows

4 жыл бұрын

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

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

3 жыл бұрын

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

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