2 ай бұрын
4 ай бұрын
4 ай бұрын
7 ай бұрын
7 ай бұрын
9 ай бұрын
11 ай бұрын
11 ай бұрын
Жыл бұрын
Жыл бұрын
Жыл бұрын
Жыл бұрын
Пікірлер
@KhurramSikandarCreative 6 күн бұрын
I added all scripts into the sheet but in automation none of the scripts showing how can I link the scripts in sheet so they can show up in automation
@BenHoward_PowerBI 6 күн бұрын
Can you run the scripts from the Excel sheet?
@KhurramSikandarCreative 6 күн бұрын
@@BenHoward_PowerBI Yes all scripts are running from excel sheet and I can see they correctly delete all tables data correctly
@KhurramSikandarCreative 6 күн бұрын
When I select Group, Document Root and Excel Sheet these in action, these all steps are ok but when it says select script then no items are showing I have added scripts in sheet and tested at code editor by running all, all are running perfectly at code editior and delete all tables perfectly. I also add scrtipts in sheet without button option but why it says no items at automation scripts. Do i missing something do i need to give any access to scripts
@BenHoward_PowerBI 5 күн бұрын
@@KhurramSikandarCreative - Hi, I am not sure why this would occur. I assume you are using the same account for both the office scripts and power automate?
@KhurramSikandarCreative 5 күн бұрын
@@BenHoward_PowerBI Definately I am using the same account for both. Once we add an script at automate section of excel sheet do we need to add them some where else also. Do I have to add their script files seperately also at the location where the excel sheet is exists or I just need to add them in excel sheet.
@mauriciocarazzodec.209 9 күн бұрын
I can't export the Planner as an Excel file since this option doesn't appear when I click the 3 dots. Do we need premium license?
@BenHoward_PowerBI 6 күн бұрын
Hi, MS have changed the UI, bit the export plan to Excel is still available from the drop down menu to the right of the plan name when you are editing a plan.
@AakritiJain-j5r 21 күн бұрын
Hey I want to place icons on certain locations on a filled map
@Dennis07-yl3cf Ай бұрын
What if the files has updates every week, just copy path would do?
@BenHoward_PowerBI 6 күн бұрын
You can just replace the old files with the newer ones (assuming that the new ones contain all of the rows that existed in the old files). If the new files just contain new records, then you need to append the files together.
@JohnBrown-hx8bq Ай бұрын
Such a shame the sound is so bad :(
@Fernando_Calero Ай бұрын
Great session @LauraGB, thank you very much for sharing! Q: How many rows are we allowed to pass in Power Automate with the action Run a query against a dataset (semantic model)?
@Fernando_Calero Ай бұрын
Great session @Sue, thank you very much for sharing! One comment, if you add the "extended=True" parameter to the list_tables function it provides insightful detail information.
@Eldedosle Ай бұрын
En el minuto 8:46 donde se confirma la ultima cuenta me aparece vacio y me permite crear una nueva conexión ¿cual seria?
@jappie1200 Ай бұрын
This Video has been a great great help. Perfectly explained in a calm way and perfect speed. Compliments and thanks!
@BenHoward_PowerBI Ай бұрын
Hi, it's pretty old now, but I'm really glad it helped - thanks for the feedback.
@thurinar 2 ай бұрын
Interesting topic, but the audio is really bad.. or is it just me?
@johnbinsc4687 15 күн бұрын
Not just you, there is an echo on the speakers voice a lot of the time. Very hard to understand.
@raghuram424 2 ай бұрын
Audio not clear. can you check it
@BenHoward_PowerBI 2 ай бұрын
Unfortunately it is how it was recorded. There isn't a lot I can do with it.
@Immortal34345 2 ай бұрын
please i need your supoort, i have a table with dates, i used a visual called scroller for power bi dashboards, i installled it but when i add date to the visual, it shows date then timestamp format, i need to show date only withoyt time, i tried your video but i dont know how to do this in the json file,, thanks
@BenHoward_PowerBI 2 ай бұрын
You cannot do this by changing the JSON file. Instead search for how to use Power Query to transform date and time values.
@Immortal34345 2 ай бұрын
@@BenHoward_PowerBI Hello Ben thanks for your reply, the visual i installed called scroller fromm app source and it takes the date ( what ever the formt is ) and convert it to the visual with date,timestamp and no hope, i did everything with the date, but when i tried to convert the date to text, the sorting was incorrect
@BenHoward_PowerBI 2 ай бұрын
@@Immortal34345 - Hi, seems like you should be contacting the people who created the application. I cannot help you.
@vasaicrow8706 2 ай бұрын
Can you please share the links at the end of the video? Thanks!
@markderbyshire100 3 ай бұрын
been struggling all day ... one view of your video and my problem is solved ... THANK YOU !!!!
@tommasoperilli4642 3 ай бұрын
Hi, is there a way to run instances in background? if i want to run 1000 instance my computer is not able to pop-up 1000 windows
@ShiftySumo 4 ай бұрын
Hey Ben, thanks for the tutorial and downloadable files, really great tutorial and clear instructions - I am currently testing the 'sequential' version of your flow, but it is currently up to 16hrs+. Does this pull all the data from planner/teams as whole and then run smaller scheduled flows to top up the excel spreadsheet tables (so to speak?), or will this run everyday and pull everything (again, another potential 16hrs+)?
@BenHoward_PowerBI 4 ай бұрын
Hi, it re-runs entirely. The reason for this is that there is no way for me to find out which tasks are new or have changed in anyway.
@alexmyers3716 4 ай бұрын
This is very needed and up to date content on the state of maps in Power BI. Thanks for posting!
@BenHoward_PowerBI 4 ай бұрын
I am glad you liked it!
@PradeepMallipudi-i7x 4 ай бұрын
what if negative average refresh time hits for reports, what does it indicates can you explain
@guille.salazar 4 ай бұрын
Excellent... Congrats 🎉🎉🎉... Thanks for your tips, it's good... Greeting from Nicaragua
@BenHoward_PowerBI 4 ай бұрын
You are very welcome. Greetings from the UK.
@maarguellol3961 4 ай бұрын
Very helpful, thank you! Do you have any tricks to skip failures if there isn't a plan in any group? I'm getting an error: type 'Null'. The result must be a valid array.
@BenHoward_PowerBI 4 ай бұрын
I have groups that don't have plans and I don't get the error, are you sure that this is what is causing it?
@maarguellol3961 4 ай бұрын
@@BenHoward_PowerBI I'm facing 403 Forbidden error, list plans for a group this will sometimes fail the condition for which it fail are if you are not a member of the group that you own "statusCode":403,"headers "message":You do not have the required permissions to access this item. expression '@outputs('List_plans_for_a_group_3')?['body/value']' is of type 'Null'. The result must be a valid array. I found this, around minute 9-10 she is doing a troubleshooting when this happen: kzbin.info/www/bejne/o6Kqd5V_fNV2mdk
@rocketedtech 4 ай бұрын
How can one import multiple tables? Can it be tables in multiple worksheets within the same workbook? Or does it have to be one worksheet in multiple Excel workbooks contained in one Sharepoint folder?
@BenHoward_PowerBI 4 ай бұрын
How to do this is beyond a simple response, however, it can be multiple tables in multiple worksheets, or you could load in multiple Excel files, or any combination of the two.
@rocketedtech 4 ай бұрын
@@BenHoward_PowerBI Ok thanks for the reply!
@OojaalaSurujhlal 5 ай бұрын
Hi Ben, thank you for this video. I am importing the zip file onto Power Automate, I notice that the zip file I downloaded is called Planner-PowerBI-with-PowerAutomate-main.zip, and your file is called AddPlannertaskstoanExcelOnlineSpreadsheet..So my upload failing. response Something went wrong. Please try again later.. Please can you assist correct. thank you
@BenHoward_PowerBI 5 ай бұрын
Hi, it won't be because the .zip file has a different name. Did you see the subsequent videos and updates to the description, such as.... To import the zip file you need to add the query parameter "v3=false" to the end of the URL when you import the file. For example from my tenant the query is make.powerautomate.com/environments/Default-746993bd-b693-45c8-8ec1-f4755c4b728a/flows/import?v3=false from kzbin.info/www/bejne/bmPEio14gM6qpaM
@nitinat3590 6 ай бұрын
Very helpful! Surprisingly only 3k views after 5 months, should have been 300k
@BenHoward_PowerBI 6 ай бұрын
Well, please share the video widely if you can. thanks!
@nitinat3590 5 ай бұрын
@@BenHoward_PowerBI I am already doing it!
@MoKa-w8x 6 ай бұрын
@BenHoward_PowerBI Is it possible to get the updated script for this particular test? The one on git hub isnt the same as this one. Thanks in advance
@messiahofdesire 6 ай бұрын
Isn't a 'group' a 'Teams Channel'?
@BenHoward_PowerBI 6 ай бұрын
No, a Teams Channel is an area for collaboration, and a group is a selection of people. There can be a 1:1 relationship between a group and a channel, but not necessarily so, eg, one group can own multiple channels.
@messiahofdesire 6 ай бұрын
Hi Ben. Great presentation - audio understood, but content relevant.
@BenHoward_PowerBI 6 ай бұрын
Glad you liked it!
@saadmansoor4395 6 ай бұрын
Great video !!! Much appreciated can we get the copy of dashboard?
@BenHoward_PowerBI 6 ай бұрын
Hi, no, it's related to Manchester Airport group, and Dave Scally has moved on from his position there.
@seankerr1187 6 ай бұрын
what is this? how do you automatically refresh THE EXCEL FILE
@BenHoward_PowerBI 6 ай бұрын
thanks for the question. This is a video which shows how to automate the Power BI refresh from an Excel file stored in Teams/SharePoint. If you want to automatically refresh the Excel file, then this assumes it is populated from another (3rd party) source. I've used Power Automate to do this in the past, an example is here where I automate the refresh of Excel with Microsoft Planner data using Power Automate. kzbin.info/www/bejne/Y4aUf6GgbpqJg9E
@TabularEditor 6 ай бұрын
Thank you for recording and publishing our talk Ben, and for organising the user group event in the first plac. Much appreciated.
@BenHoward_PowerBI 6 ай бұрын
Our pleasure - it was a great session.
@dayanagelvez5610 6 ай бұрын
Hi Ben, thank you so much for sharing this, the video and files are incredibly helpful! - I'm stuck in the part where I have to open the .pbit file; I entered the URL of the excel file but right after that I get message to "Access Web content". I tried using my credentials, but I keep getting a "We couldn't authenticate with the credentials provided-Please try again" message. I also tried using my boss credentials since she is the Global admin but keep getting same error. Do you know what could be causing this problem? Appreciate any advice I can get! Thanks again.
@BenHoward_PowerBI 6 ай бұрын
Hi, I assume your URL is in the following format? tenant.sharepoint.com/sites/APOGroup/Shared%20Documents/PlannerTasks.xlsx. If you can't fix it reach out to me and we can schedule a teams call to try and fix.
@dayanagelvez5610 5 ай бұрын
@@BenHoward_PowerBI Hi Ben, I was able to fix the error. Now, I'm running into another issue: all my plans are ongoing plans with ongoing tasks, and I just need to track and visualize In Progress, late and Not started tasks, I don't need the completed tasks, and I think that's why the flow is taking so much time because is listing ALL tasks. Is there a way to run the flow without the completed tasks? Appreciate any advice you can give me. Thank you!
@BenHoward_PowerBI 5 ай бұрын
@@dayanagelvez5610 - I don't think there is any way to build that logic into the Power Automate - but I will check.
@shaileshshriwas378 6 ай бұрын
Hello can you please provide updated script ??
@jackscott4521 7 ай бұрын
Is it possible for this to only run to extract the tasks and checklists from only 1 planner from 1 group/team? At the moment mine is pulling all the tasks from all my groups and teams and runs for an unnecessarily long time. I'm very new to PowerBI and PowerAutomate so please excuse my lack of knowledge if this is a simple question.
@BenHoward_PowerBI 7 ай бұрын
Hi, yes, check out this flow - github.com/ben-howard/Planner-PowerBI-with-PowerAutomate/tree/main/Single%20Team
@jackscott4521 7 ай бұрын
@@BenHoward_PowerBI Thanks! I can't get the Office Scripts to work, is it simple enough for me to set up the single team flow as per the standard initial flow in your github?
@BenHoward_PowerBI 7 ай бұрын
@@jackscott4521 - is it that you cannot get the scripts to work, or you do not have access to scripts at all?
@jackscott4521 7 ай бұрын
@@BenHoward_PowerBI I don't have access to scripts in my org
@BenHoward_PowerBI 7 ай бұрын
Yes, then you will have to use the process for removing all the rows from the excel sheets as per the standard initial flow. Because you are only synching a single team/planner plan then you shouldn't see any performance issues (assuming you don't have thousands of tasks!)
@louiem1101 7 ай бұрын
Ben - the New Planner does NOT allow Export to Excel ??
@BenHoward_PowerBI 7 ай бұрын
There is no "new" planner, there is the original planner @ tasks.office.com/ and there is project for the web @ project.microsoft.com/ - both support export to Excel.
@mmmmryl 7 ай бұрын
requesting a tutorial on transit routes in Icon Map as well
@BenHoward_PowerBI 7 ай бұрын
Noted
@showa3601 8 ай бұрын
Hi Ben, Thanks a lor for this video and you useful insights! I was trying to draw the ppwer automate flow chat by myself but I blocked since in the "add row into a table" task I'm not able to find all the "value" dynamic plannwr contens to fill the several columns of the table. Could you please tell me why it happens? Thanks so much Marco
@BenHoward_PowerBI 8 ай бұрын
Hi Marko, if you reach out to me via email (you'll find my email address in the Power BI template) or online etc, then we have a look via a teams call.
@showa3601 8 ай бұрын
@@BenHoward_PowerBI Hi Ben, you are so available! However I fixed it! Thank you so much
@BenHoward_PowerBI 8 ай бұрын
@@showa3601 - Fantastic - great job!!
@mounikajetti4995 8 ай бұрын
Hi, I have a slightly different challenge, my workbook is located in sharepoint and I have a power_automate flow that takes in the data from this workbook. The issue is this workbook has external links from which it's getting data. Now unless i keep this workbook open I am not getting any updated data for my flow. How to keep refreshing those links even when the workbook is closed!? If you have any idea please help:)
@BenHoward_PowerBI 8 ай бұрын
Yes, I would create a PowerAutomate script that opens and refreshes the Excel file, and incorporate this new script into the current one at the beginning.
@flexyourdata 8 ай бұрын
Thanks. Great video. It's wild to me that we have to use error bars to achieve this effect.
@BenHoward_PowerBI 7 ай бұрын
Glad it was helpful!
@saurabhroy99 8 ай бұрын
Hi Ben, Thanks for the video. How to run / update the scripts for multiple reports ?
@saurabhroy99 8 ай бұрын
Hi Ben, Thanks for the video. How to run / update the scripts for multiple reports ?
@umajeyaraman5130 9 ай бұрын
Hello , Is the power automate workflow removed from Git?
@BenHoward_PowerBI 9 ай бұрын
No - github.com/ben-howard/Planner-PowerBI-with-PowerAutomate
@umajeyaraman5130 9 ай бұрын
@@BenHoward_PowerBI I figured out its inside the folder now , thanks a lot for helping with this video
@umajeyaraman5130 8 ай бұрын
@@BenHoward_PowerBI Hey Ben, Is there a way to extract task from Teams sub channels ?
@BenHoward_PowerBI 8 ай бұрын
@@umajeyaraman5130 - hi, can you elaborate on the question please, I am not sure what you mean?
@Al-vl3tp 9 ай бұрын
Were is your updated script? Can you add the link in the description of this video?
@bartekwachocki8637 9 ай бұрын
Would it work with PowerBI Report Server?
@SusanBoyles-ld2nr 9 ай бұрын
Very Helpful and Love the pace you use as well (yes, we can pause, but some speak fast and don't have to rewind and rewind to understand what was said).
@BenHoward_PowerBI 9 ай бұрын
Thanks for the great feedback. Hope this helps you out.
@rebekahlivsey1736 10 ай бұрын
I have a visual I wanted to have 1 row, 13 columns, so l'II definitely be giving this a go (l ended up splitting it into 3 side by side charts, a less elegant hack) thanks for the video!
@BenHoward_PowerBI 10 ай бұрын
Hi, That's great, let me know how you get on. We ended up without labels for the categories on the Y-axis, but just added them in manually as text fields. Obviously once you have edited the .pbip file, you can save back as a .pbix file if you need to (which we did!)
@rebekahlivsey1736 10 ай бұрын
@BenHoward_PowerBI worked great, easy to follow your tutorial and 13 columns worked a treat! Thanks 👍
@nishantkumar9570 10 ай бұрын
Awesome hack! Thanks so much. It opened up so many possibilities and have so many use cases. We can no longer be limited to UI.
@BenHoward_PowerBI 10 ай бұрын
wow - that was fast... Bot?
@chollyeva 10 ай бұрын
do you need to have power bi desktop to make this happen or can you just use power bi service? apologies for the ignorance here, im a new user.
@BenHoward_PowerBI 10 ай бұрын
Hi, no problem. You need the desktop in order to connect to Excel file
@harrytubman 10 ай бұрын
Great video
@BenHoward_PowerBI 7 ай бұрын
Thanks!
@mariaf4032 11 ай бұрын
Hi Ben !!! I have a problem , I have the same error when I import the data that you explain , but in “next steps …” I don’t have the link of “Save as a new flow” so I can not check the path of the tables as you do ! Do u have a solution ? Thanks so much
@mariaf4032 11 ай бұрын
Maybe I am not taking the right zip to import 😢
@BenHoward_PowerBI 11 ай бұрын
I am sure you are using the right zip file. Did you see the comment re using ?v3=false ?
@mariaf4032 11 ай бұрын
Hi!!! Yes ! I add that query parameter to the URL before import the file . And after I recibe the error but it doesn’t appear the link to check the path .
@MaksimBlekhshtein 11 ай бұрын
Hello Ben, first of all thank you very much for this solution, I like it very much. I am exploring powerBI and started from web version, I have some troubles with uploading your .pbit template. Could I maybe ask you to share .pbix file which is suitable for uploading to powerBI service? Thank you in advance!
@BenHoward_PowerBI 11 ай бұрын
Hi, for sure, can you send me a mail, you'll find my address in the .pbit file, or contact me via my website (applepark.co.uk)
@MaksimBlekhshtein 11 ай бұрын
@@BenHoward_PowerBI , thank you for your quick response, I was able to find a person with access to Power Bi desktop, so we did necessary implementations. But now I have a further question, how do you construct "Task URL" column in your data model? I did not find it to be exported during the flow
@BenHoward_PowerBI 11 ай бұрын
@@MaksimBlekhshtein - the task URL is included in the .pbit that you can download from GitHub, but for ref the URL is constructed in Power Query. Here is the PQ code that does it. // Add in the task URL #"Added Custom" = Table.AddColumn(#"Changed Type", "Task URL", each "tasks.office.com/"&Lines.ToText(Tenant)&".onmicrosoft.com/en-us/Home/Task/"&[Task ID]), #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Task URL", type text}}), #"Cleaned Text" = Table.TransformColumns(#"Changed Type1",{{"Task URL", Text.Clean, type text}})
@MaksimBlekhshtein 11 ай бұрын
Thank you @@BenHoward_PowerBI! I will try to find it in my environment.
@carloscantu75 11 ай бұрын
Great content, thanks for sharing!
@BenHoward_PowerBI 11 ай бұрын
Glad you enjoyed it!