![Ben Howard](/img/default-banner.jpg)
- Видео 122
- Просмотров 429 220
Ben Howard
Великобритания
Добавлен 17 авг 2011
Power BI and Project Server consultant and Microsoft MVP based in the UK, delivering Power BI consultancy and training world wide.
www.applepark.co.uk
www.applepark.co.uk
Geospatial Analytics and Advanced Mapping in Power BI
James Dales - Geospatial Analytics with the Icon Map Pro visual
In this session, James dives deep into the world of geospatial analytics, showcasing back-to-back demos and exploring the powerful capabilities of Azure Maps and ArcGIS visuals in Power BI. If you’re keen on elevating your data visualization skills, this session is a must-watch
About James:
CEO at Tekantis
London, United Kingdom
Having previously led the Power BI and Microsoft Fabric capabilities at both UK and global level for a large multi-national Microsoft consultancy, James has recently established a new, ambitious data company Tekantis, enabling him to focus on geospatial analytics and data products.
James is a Microsoft Data...
In this session, James dives deep into the world of geospatial analytics, showcasing back-to-back demos and exploring the powerful capabilities of Azure Maps and ArcGIS visuals in Power BI. If you’re keen on elevating your data visualization skills, this session is a must-watch
About James:
CEO at Tekantis
London, United Kingdom
Having previously led the Power BI and Microsoft Fabric capabilities at both UK and global level for a large multi-national Microsoft consultancy, James has recently established a new, ambitious data company Tekantis, enabling him to focus on geospatial analytics and data products.
James is a Microsoft Data...
Просмотров: 453
Видео
Tabular Editor 3 - Semantic Modelling at warp speed
Просмотров 3412 месяца назад
Join us for an exhilarating journey through the cosmos of data modeling with Tabular Editor 3, the ultimate productivity tool for Power BI and Analysis Services semantic models. In this session, we will explore the features that propel Tabular Editor 3 light-years ahead of the competition, enabling you to achieve unparalleled efficiency and precision in your data modeling endeavors. Guided by t...
The Kusto experience in Fabric - Brian Bønk
Просмотров 2013 месяца назад
Want to make a cutting edge data platform using Kusto in Fabric? Then come along for a journey into the world and wonders of Kusto and the new Streamevent service in Fabric. In this session I will guide you through the experience and close collaboration between Fabric and the Kusto database and querysets. Along with how to help Power BI get the most out of your Kusto database with small tweeks....
Advanced Incremental refresh in Power BI - Mark Endicott
Просмотров 1,2 тыс.3 месяца назад
Incremental Refresh is nothing new in Power BI, and if you’ve got a large data model it can really help look after your Power BI environment. But what if your requirements for data refreshing are a bit more bespoke? What if you need to customise things a little bit? In this talk we’ll look at ways we can leverage the use of the XMLA Endpoint to implement Advanced Partitioning. About Mark Endico...
Power Platform & Fabric build
Просмотров 2133 месяца назад
Power Platform and Fabric both include low-code features. This means that development can be fast and done by the business. We can come up with an idea and create a proof of concept with some working parts and good plan going forward within days, if not hours. We will include multiple features from the Power Platform and Fabric to solve a real business problem. In this session we will take a re...
PBI Inspector
Просмотров 3495 месяцев назад
Testing the visual layer of Power BI reports has usually been a manual task. Thanks to the new Power BI Project file format however there is an opportunity to automatically check for visuals' issues around accessibility, consistency and performance and thereby align with your organizations Power BI Centre of Excellence guidelines. In this session we will see how PBI Inspector, an open-source co...
Pets at Home “The Journey from Tableau to Power BI self-service”
Просмотров 3195 месяцев назад
As-Is describing our Tableau viz solution on data sets supporting reporting Setting the Standards Themes Governance & Control Dax Standardisation Domain based semantic models How we identified the domains Aspiring to few models supporting many reports -Considerations on when to use direct query with GCP (Drill throughs) - demo hopefully with some example costs reporting - Challenges on how to a...
Edit (and hack) Visuals when saved to Power BI Project File type
Просмотров 3005 месяцев назад
Learn how to edit the Power BI Project File type so that you can change the properties of a visual. This is a useful trick if the UI does not support exactly what you want it to do, for example when you need more than 6 rows or columns on a small multiples chart.
Matt Lakin - Get a Load of this - Realistic Load Testing for Power BI, explained!
Просмотров 9136 месяцев назад
Do you have Power BI reports that work great during development and UAT, but performance drops once released to production with multiple users? Or perhaps you're a decision maker, and want to know how much Premium capacity to buy? Or whether you need to invest in Fabric? You need automated Power BI Load Testing! In this session we will discuss Power BI production report performance woes by answ...
Andy Cutler - Synapse Data Warehousing in Fabric: It's all just SQL...Or is it?
Просмотров 1966 месяцев назад
Fabric is Microsoft's new platform on the block, covering the world of lakehouses, warehouses, real-time streaming, data engineering, and Power BI data modelling and reporting. In this session we'll be looking at the Microsoft Fabric Warehouse service and how it differs from the SQL services we all know and love from Microsoft. We'll look at how and why it's different, and dive into the differe...
Chris Webb - Fabric Direct Lake Deep Dive
Просмотров 3,5 тыс.7 месяцев назад
One of the coolest things about Microsoft Fabric is the new Power BI Direct Lake mode, where you can build reports on data in your data lake without needing to import it. In this session you'll learn all about Direct Lake mode: how it works, why you might not get it to work, how to monitor it and more! Speaker Details - Chris Webb Specialist in Fabric, Power BI, Analysis Services, MDX, Power Pi...
Microsoft Fabric : Notes From the Field
Просмотров 5177 месяцев назад
Session 1 - Ian Pike - Microsoft Fabric : Notes From the Field A dive into Microsoft Fabric. Working closely with Customers to understand the benefits of using Microsoft Fabric and the learnings to get you started or avoid the pain points. Microsoft Fabric is GA so people are going on a journey to see how it can be implemented in existing platforms, or for a greenfield project. A look at the cu...
PBIMCR - The Very Group
Просмотров 2329 месяцев назад
External Sharing and Data Labs The Very Group BI Team implemented Power BI as their enterprise reporting tool in 2019 and have steadily grown adoption since then, constantly looking for ways to evolve the operating model to offer a better service to the business. Two recent innovations that show great potential are external sharing (allowing third parties to access Power BI reports in a control...
PBIMCR Mastering the Power BI Lifecycle: From Data Connection to Git Integration - Session 1
Просмотров 5479 месяцев назад
We will be exploring the comprehensive Power BI development lifecycle, spanning from data connection and data modelling to advanced enterprise ready deployment techniques. This session will equip you with essential knowledge to build efficient Power BI solutions. We will dive into data transformation, cleansing, and modelling best practices for data primed for impactful visualizations. In this ...
PBIMCR - Mastering the Power BI Lifecycle: Git Integration
Просмотров 3139 месяцев назад
We will be exploring the comprehensive Power BI development lifecycle, spanning from data connection and data modelling to advanced enterprise ready deployment techniques. This session will equip you with essential knowledge to build efficient Power BI solutions. We will dive into data transformation, cleansing, and modelling best practices for data primed for impactful visualizations. In this ...
PBIMCR - KPMG - Dashboard UX and Figma Demonstration
Просмотров 31511 месяцев назад
PBIMCR - KPMG - Dashboard UX and Figma Demonstration
PBIMCR - LDI Quiz Analytics in Microsoft Fabric
Просмотров 183Год назад
PBIMCR - LDI Quiz Analytics in Microsoft Fabric
PBIMCR - What's new for Power BI Source Control - Mathias Thierbach
Просмотров 776Год назад
PBIMCR - What's new for Power BI Source Control - Mathias Thierbach
PBIMRC - C# Scripting for Tabular Editor
Просмотров 386Год назад
PBIMRC - C# Scripting for Tabular Editor
PBIMCR - Bookmarks, everything you need to know
Просмотров 324Год назад
PBIMCR - Bookmarks, everything you need to know
PBIMRC - Deneb: Declarative Visualization in Power BI
Просмотров 2 тыс.Год назад
PBIMRC - Deneb: Declarative Visualization in Power BI
PBIMCR - The Data Model is Key - Sean Best
Просмотров 332Год назад
PBIMCR - The Data Model is Key - Sean Best
PBIMCR - Direct Query with Chris Webb
Просмотров 8 тыс.Год назад
PBIMCR - Direct Query with Chris Webb
PBIMCR - Visual story telling for the end user
Просмотров 672Год назад
PBIMCR - Visual story telling for the end user
PBIMCR - Power BI Metrics with Chris Wagner
Просмотров 1,7 тыс.Год назад
PBIMCR - Power BI Metrics with Chris Wagner
PBIMCR - An Introduction to Machine Learning with Leon Gordon
Просмотров 314Год назад
PBIMCR - An Introduction to Machine Learning with Leon Gordon
This is very needed and up to date content on the state of maps in Power BI. Thanks for posting!
I am glad you liked it!
what if negative average refresh time hits for reports, what does it indicates can you explain
Excellent... Congrats 🎉🎉🎉... Thanks for your tips, it's good... Greeting from Nicaragua
You are very welcome. Greetings from the UK.
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.
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?
@@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: ruclips.net/video/mqGFbIGpCcw/видео.html
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?
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.
@@BenHoward_PowerBI Ok thanks for the reply!
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
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 ruclips.net/video/82aYZBKiwoA/видео.html
Very helpful! Surprisingly only 3k views after 5 months, should have been 300k
Well, please share the video widely if you can. thanks!
@@BenHoward_PowerBI I am already doing it!
@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
Isn't a 'group' a 'Teams Channel'?
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.
Hi Ben. Great presentation - audio understood, but content relevant.
Glad you liked it!
Great video !!! Much appreciated can we get the copy of dashboard?
Hi, no, it's related to Manchester Airport group, and Dave Scally has moved on from his position there.
what is this? how do you automatically refresh THE EXCEL FILE
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. ruclips.net/video/-U1Nnj95VMo/видео.html
Thank you for recording and publishing our talk Ben, and for organising the user group event in the first plac. Much appreciated.
Our pleasure - it was a great session.
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.
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.
@@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!
@@dayanagelvez5610 - I don't think there is any way to build that logic into the Power Automate - but I will check.
Hello can you please provide updated script ??
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.
Hi, yes, check out this flow - github.com/ben-howard/Planner-PowerBI-with-PowerAutomate/tree/main/Single%20Team
@@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?
@@jackscott4521 - is it that you cannot get the scripts to work, or you do not have access to scripts at all?
@@BenHoward_PowerBI I don't have access to scripts in my org
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!)
Ben - the New Planner does NOT allow Export to Excel ??
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.
requesting a tutorial on transit routes in Icon Map as well
Noted
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
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.
@@BenHoward_PowerBI Hi Ben, you are so available! However I fixed it! Thank you so much
@@showa3601 - Fantastic - great job!!
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:)
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.
Thanks. Great video. It's wild to me that we have to use error bars to achieve this effect.
Glad it was helpful!
Hi Ben, Thanks for the video. How to run / update the scripts for multiple reports ?
Hi Ben, Thanks for the video. How to run / update the scripts for multiple reports ?
Hello , Is the power automate workflow removed from Git?
No - github.com/ben-howard/Planner-PowerBI-with-PowerAutomate
@@BenHoward_PowerBI I figured out its inside the folder now , thanks a lot for helping with this video
@@BenHoward_PowerBI Hey Ben, Is there a way to extract task from Teams sub channels ?
@@umajeyaraman5130 - hi, can you elaborate on the question please, I am not sure what you mean?
Were is your updated script? Can you add the link in the description of this video?
Would it work with PowerBI Report Server?
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).
Thanks for the great feedback. Hope this helps you out.
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!
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!)
@BenHoward_PowerBI worked great, easy to follow your tutorial and 13 columns worked a treat! Thanks 👍
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.
wow - that was fast... Bot?
How you have done that Transit Routes in Icon Map can u please do a video on Transit Routes
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.
Hi, no problem. You need the desktop in order to connect to Excel file
Great video
Thanks!
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
Maybe I am not taking the right zip to import 😢
I am sure you are using the right zip file. Did you see the comment re using ?v3=false ?
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 .
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!
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)
@@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
@@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}})
Thank you @@BenHoward_PowerBI! I will try to find it in my environment.
Great content, thanks for sharing!
Glad you enjoyed it!
Thank you! Great vid, very helpful! BUT, those limitations are total show stoppers. I'm looking forward to when fabric matures, but it sure doesn't seem ready for prime time yet. And it seems that the "guard rails" are likely to be serious limitations. You mention row limitations, but what about width? Also, I hope there is a plan to develop a path for translating PBIs in desktop to use this. If I have to rebuild all of my models from scratch, that is another block. What I don't understand is where all of the data modeling that I currently do in azure sql would happen in this new world? I hope this evolves to be usable - conceptually it's great. But for now, it doesn't appear to be a viable option for real world use - yet!
I think the idea is that you do your data modeling in Power Bi as a semantic model for Fabric.
@@ws3457 Yeah there's no way I could efficiently do the extensive modeling required to create a star schema in pbi. That needs to happen earlier in the chain of events (upstream), as per Roche's Maixm!
@@Tom-kp2lvThat it does!
46:06 so we can control when the new data is available to Direct Lake so data consistent. Such as both Sales and Inventory data changing at the same time.
26:14 killer Direct Lake feature is reuse of dimensions with shortcuts.
They’re using a pbix file with 4m rows as a source for other reports? Why not Azure? Even power bi datamarts?
Fabulous information ❤it . This is what I am looking for. Thanks for the treasure.
It works. 🙂
Great!!
I am attempting to import the package into Power Automate and, after changing the import setup to "Create as new", I am not able to see or assign connection for each resource type. Do you have thoughts on the cause?
Hi, you need to set up connections for each resource type, you can do this from the connections tab in Power Automate, click on New Connection, and then it's best to use the search box in the top right (eg Excel) and then create your connection. Hitting refresh then back in the Power Automate import wizard on the connection will show you the new connection for the relevant connection type.
HI Ben, i cant get this to import even with your update
Okay, and what error do you specifically get?
@@BenHoward_PowerBI Flow save failed with code 'MultipleErrorsOccurred' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetSingleScript' failed with status code 'NotFound'
It goes on quite a bit looks like it cant read it
Thank you for this! However, what happens if you use python to generate csv files each month which contains new records. Is it still possible to update Power BI dashboards with the latest csv file?
Which one do you think would be better to invest my time on Vega or Vega-Lite
Great presentation!
Thank you for this example. I am having 1 issue. All of the task are not being removed so I'm getting an error. I have duplicates. Any ideas on how I need to modify the flow to ensure that all of the existing data gets removed. So that I get a complete data refresh?
Hi Ben, any suggestions where we have 27+ plans so the flow is taking a long time. I also removed the parallel flows and made it concurrent as it constantly errored out..
If it is timing out it is because you are hitting limits put in place by Microsoft. How long is a long time?
@BenHoward_PowerBI thanks for your quick reply. Usually 22 hours, I've seen it running for 1 day 22 hrs when I turned off the daily refresh to see what happens
@@alannahsteevens5102 - wow, that is soooo long... I'm trying to work on soln that uses the graph API but don't have much spare time at the moment - it *might* be quicker but who knows.
@@BenHoward_PowerBI I have used the graph API and it still times out. I think you're correct that it's the call limits per license, I turned off all other flows in our organization that weren't sensitive and it ran successfully taking 3 hrs again
Hey, thank you for the video although I tried making your workflow but for me the loop never ends, and I get timeout error and thus no data is imported into excel. can you please guide me through it? Thanks in advance.
Hey thank you and I really appreciate it but for some reason for me there is no option of " create as new flow" in next steps doesn't come. What to do then?
Hi, can you reach out to me via email via the contact form on applepark.co.uk and we can share a screen to see the issue?