What if you are building a report that you want to have no maintenance on from year to year? Doesn't the parameters you set in PowerQuery limit your data to only the current year, and by 2022 you no longer have current data?
@sameerulhaq40663 ай бұрын
What if I want it to detect filter manager based on cascading filter. Like if I select business car it should filter all the managers for cars in the managers option and the Item code, time/ date should be automatically select without the need to bee selected manually like if the user selects item code A it should aslo show in the form Item A managers they can select and email ID also by default based on whoever logged in they cant change these?
@hadiltlijani59733 ай бұрын
Hello, thank you so much for the tutorial! It was very helpful. My question is, when embedding my report to the company website online, will the external users see it with the company fonts or the default fonts? I know that the issue persists on the PowerBi service but what about embedding the report?
@VaddiBhargavi-j2fАй бұрын
Yes, I too have the same doubt
@Phoenixspin6 ай бұрын
Neat trick.
@ShaunaGuner6 ай бұрын
Great concise video. However, I am getting an error in the Create HTML table step - "The 'from' property value in the 'table' action inputs is of type 'Null'. The value must be of type 'Array'. Is this because some columns are blank for some items? Is there any way to make this work? Thank you!
@emmanuell15233 ай бұрын
Hi Could you fix it?
@MichaelGallegos7 ай бұрын
As a New user. This looks easy. But so many steps I feel like if I miss a step I would not know where to troubleshoot
@carlycarlyle8 ай бұрын
Nice. What if your attachments are links and not standard attachments?
@jonellemorgan5159 ай бұрын
Nice! this might be the answer to all my problems 😅😅😅😅😅😅
@johnwessel-20579 ай бұрын
Do you have a video explaining the email button and how someone would enter that?
@VieraPristicova10 ай бұрын
Thank a lot for this amazing video! :)
@JimButler2111 ай бұрын
Love this video. Thank you! My guess is this allows you to also playback videos much more smoothly than if you were doing so via screenshare. Would you say that's the case?
@mathsilvads Жыл бұрын
THANKS!!
@LenkaStašková-s3r Жыл бұрын
after few videos this finally works
@shrutirao9362 Жыл бұрын
Thank you, really helpful
@inoxide5454 Жыл бұрын
great. imma have a diplodocus bowling through all my high-level corporate meetings now.
@lokeshsansarwal6156 Жыл бұрын
How to move this saved file in dropbox to our local drive?
@trentinman3745 Жыл бұрын
I have followed instructions from several videos including yours. I am attempting to get Power Automate to download a CSV file. Every time I run the rest the file that is downloaded is not the data that is inside the CSV if you manually download it from the email. Does anyone have any input that may assist me with this?
@mdaj13 Жыл бұрын
Hi, thanks for creating this video. I'm trying to do something similar but I want to show regions and local authority districts on the same mapbox visual. Do you know if that is possible? I have the regions and LADs shapefiles from ONS but can't get the visual to show them at the same time.
@АннаКарпенко-к6э Жыл бұрын
Exactly what I was looking for!
@moviemaster5039 Жыл бұрын
Related Power Apps also make some videos
@moviemaster5039 Жыл бұрын
❤
@brendannicolas2549 Жыл бұрын
Thank you for this!
@sanprasa1 Жыл бұрын
Hi , I created an Export to excel power automate flow in my power bi dashboard, it works completely fine except it creates file only in my one drive folder not in the users onedrive when they run the flow from published dashboard. any clue whats wrong. Thanks
@nrnoble Жыл бұрын
This does not work with a paid subscription to Office 365 "personal" Edition, and is unlikely to work with any free version of Office 365. Speculating, Power Automate only works with office 365 with site licenses, such as companies, universities, etc.
@jeanninemcwhorter919 Жыл бұрын
NO WONDER I CAN'T MAKE THIS WORK! SO I BOUGHT A DOMAIN, WILL IT WORK USING THAT?
@nrnoble Жыл бұрын
@@jeanninemcwhorter919 I can't say for certain, but based on my research it requires a licensed version of Office 365 that includes Automate, and the "Personal" edition of Office 365 does not include automate. Students at colleges\universities may have it included, and employees of companies that have site licenses.
@jeanninemcwhorter919 Жыл бұрын
I do have a licensed subscription
@Parkwaydriver Жыл бұрын
Very helpful, thanks!
@ToriSugden Жыл бұрын
I too spent a day trying to sort this out and your way was the only way that worked. Thanks!
@adlinaisa1605 Жыл бұрын
Can we send email without click the button?
@sachinchavan1631 Жыл бұрын
Use scheduled flow and use run against power-Bi dataset with your query.
@raymondchong6573 Жыл бұрын
Great video, thanks
@andybolton7345 Жыл бұрын
Awesome video, really helpful. Is there a way to link it to multiple charts so it calculates the max of both line graphs and scales them both the same?
@АдиИ-ь8н Жыл бұрын
hello! i need your help. let's imagine that [profit] mesure has inside 'criteria type of plan' , which has 3 type: forecast, actual and budget. and for me is very important to choose min or max out of 'type of plan'. right now [pofit] is avg all 3 types of plan. how do I add this fliter/condition in this formula?
@peterjoseph11972 жыл бұрын
What if I wanted to do something similar but by file name rather than type? Perhaps the first 2 characters of a file name?
@Matt-zp9jg Жыл бұрын
Not sure if the Mid function works in Power Automate but I thats the way to go.
@clipe842 жыл бұрын
excellent!! thank you for your help!!
@user-ec1jk1oz5j2 жыл бұрын
Ive been trying so hard to find a solution to my problems wrt mapbox filtering layers n you hv brought me a step closer. Thank you!
@ianventer28672 жыл бұрын
I've been searching for this solution for about a day. There are so many websites with purported solutions to the inactive relationship drill through problem but your solution is the only one that actually worked for me. And its so easy. Thank you for making this content available it has helped me so much.
@krzysztofgorski80752 жыл бұрын
This works only if you are the user, if another user looking at the published dashboard clicks the button, the file will be saved in a location that he might not have access too or do not know where it is at all... how another user can use this button and select a specific path he wants the data to be exported to?
@1472122 жыл бұрын
Loved the high level comparison. Looking forward to the more detailed comparison such as performance against big data sets. Thanks
@abdellatifboudelal1672 жыл бұрын
Hey man thanks for the video, can I save the attachments to a local folder 📁 on my pc instead??
@majdalhamad6921 Жыл бұрын
Hi man, did you know how to do it?
@stacyloiacono23612 жыл бұрын
Thank you! This is really going to help me out! Well done.
@databuck15992 жыл бұрын
I have a similar problem, but it's for a stacked bar chart. So for mine, say I have "Month" on the X axis, and the measure (which it is a measure, not a column) is "Cost". They're being stacked by "Phase". I'm having trouble replicating this, since I need to essentially SUMX across different "Phase" values, and then take MAXX across different "Month" values. Along with the fact that I'm not sure your method can be done when it's not a column, but a measure. Any advice?
@databuck15992 жыл бұрын
Maybe some more helpful context: I don't care about the "All" functionality, I want it to change based on filters. So really I'm fine with the "Auto" functionality, the reason I'm trying to use this method is because I'm trying to force another chart's y axis to have the same y maximum as this one (when that chart uses a different measure/table).
@mulder902 жыл бұрын
Can you trigger the button on a schedule? Like automate it?
@simontaylorzhang89722 жыл бұрын
Curious to know how.
@josephtonzo46682 жыл бұрын
Hello Wise Owl! I was wondering if you could automate the flow to run every 4 hours or any other designated frequency?
@navaneetharajuramesh84622 жыл бұрын
Hi, I want the excel sheet should store in users one drive account, the user who clicked the button in Power Service. can you please help this.
@guirecpiriou99312 жыл бұрын
Thanks a lot, saved my day ! :)
@WiseOwlShorts2 жыл бұрын
Glad to hear that!
@prashantrai59112 жыл бұрын
Need more videos on Power automate desktop brother especially dynamic selector
@WiseOwlShorts2 жыл бұрын
For dynamic selector do you mean handling errors within the browser UI?
@prashantrai59112 жыл бұрын
@@WiseOwlShorts yes sometimes if click some button that button postion changes dynamically in every click for that we have to make our selector dynamic according to button position
@NickWindham2 жыл бұрын
Great quick how to
@WiseOwlShorts2 жыл бұрын
Thank you :-)
@farithahamed35992 жыл бұрын
How we can automate sending emails using power automate with customized attachments and message for a group of teams. I know this doing using mail merge but is there more a simpler way ?
@WiseOwlShorts2 жыл бұрын
Good question, I will see about a video :-)
@amang70182 жыл бұрын
much needed this video,…. thanks alot💯✌🏼
@WiseOwlShorts2 жыл бұрын
Thanks for watching, always looking for video ideas if you have Qs.
@PankajNegi0072 жыл бұрын
Great Sir Waiting
@WiseOwlShorts2 жыл бұрын
Awesome thanks :-)
@bigger3025392 жыл бұрын
Cool
@PankajNegi0072 жыл бұрын
Nice Information Keep it up Sir ... its humble request if possible make series on Power Automate Desktop
@WiseOwlShorts2 жыл бұрын
Thanks! The next video Automation with Power Automate is an introduction video. I will add Power Automate series to the list, cheers!