- Видео 431
- Просмотров 2 534 736
Havens Consulting
США
Добавлен 20 апр 2015
Headquartered in Kirkland, Washington and servicing clients all over the world. Havens Consulting provides Business Intelligence solutions to help companies use their data to operate efficiently and profitably. We utilize the Power Platform stack, which includes Power BI, PowerApps, and Microsoft Flow. We also provide consulting for Tabular Modeling, SQL Server Analysis Services, Azure Analysis Services, PowerPivot, and other analytics software to help companies realize their goals. A variety of on-site and remote technology training's are also one of the many services we provide.
Whether you’re an analyst, report developer, manager, or small business owner, we will not only add value to your organization, but we’ll also revolutionize the way you use data. We bring extensive experience and professionalism to every project and customize our services to your individual needs and concerns.
Whether you’re an analyst, report developer, manager, or small business owner, we will not only add value to your organization, but we’ll also revolutionize the way you use data. We bring extensive experience and professionalism to every project and customize our services to your individual needs and concerns.
Cross-Highlighting a Visual Using a Slicer ?!?
Learn how to leverage some recent native visual features plus a little bit of [DAX] magic to use a slicer to create a cross-highlight effect on a visual. Cross-highlighting is normally only natively available between visuals, not slicers. So tune into learn more!
BECOME A CHANNEL MEMBER 🎉
-- ruclips.net/channel/UCjlfQwqb-0S40XQ8seYPLSwjoin
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spring.com/
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- HavensBI
-- www.linkedin.com/in/reidhavens
-- ruclips.net/user/HavensConsulting
-- havensconsulting
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsult...
BECOME A CHANNEL MEMBER 🎉
-- ruclips.net/channel/UCjlfQwqb-0S40XQ8seYPLSwjoin
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spring.com/
LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟
-- HavensBI
-- www.linkedin.com/in/reidhavens
-- ruclips.net/user/HavensConsulting
-- havensconsulting
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog -- www.havensconsult...
Просмотров: 687
Видео
Easy-to-Read Multi-Variance Native Visual in Power BI
Просмотров 1,1 тыс.День назад
Learn how to combine a series of native visual features to add multiple variance bars/lines to a stacked column chart, leveraging only native visuals. Tune in to learn more! BECOME A CHANNEL MEMBER 🎉 ruclips.net/channel/UCjlfQwqb-0S40XQ8seYPLSwjoin CHECK OUT OUR MERCH STORE 👕 havens-consulting.creator-spring.com/ LET'S CONNECT! 🧑🏽🤝🧑🏽 🌟 HavensBI www.linkedin.com/in/reidhavens rucli...
Different Approach to a Auto-Scaling Date Axis in Power BI
Просмотров 1,1 тыс.21 день назад
Learn about an updated technique I applied after getting inspiration from another RUclips video showing this original technique. This approach achieves the result of a dynamic date axis that scales to your filtered date range, but with less model additions than the original approach. But while still using Field Parameters and some clever DAX. Tune in to learn more! RELATED CONTENT 🔗 Original Te...
Comparing Performance Analyzer Data (After Page Optimization)
Просмотров 605Месяц назад
Learn how to interpret and review the Power BI Performance Analyzer data export (JSON). Plus leverage a template I built to let you compare two Performance Analyzer output files to see both the differences in page load time and object (visual) counts. Tune in to learn more! BECOME A CHANNEL MEMBER 🎉 ruclips.net/channel/UCjlfQwqb-0S40XQ8seYPLSwjoin CHECK OUT OUR MERCH STORE 👕 havens-consulting.c...
Maintaining Query Folding when Merging with Different Data Types
Просмотров 987Месяц назад
Learn how to maintain your query folding when needing to merge (join) queries in Power Query, but when the merge keys are different data types, and when converting data types might initially break your query folding. Tune in to learn more! RELATED CONTENT 🔗 Query Folding Overview learn.microsoft.com/en-us/power-query/query-folding-basics BECOME A CHANNEL MEMBER 🎉 ruclips.net/channel/UCjlfQwqb-0...
Learning Advanced Text Filters with the DAX Query View
Просмотров 1 тыс.Месяц назад
Learn how to review visual query DAX code using the DAX Query View to identify efficient ways to apply advanced text filter techniques. Tune in to learn more! RELATED CONTENT 🔗 Optimizing Text Search in DAX - www.sqlbi.com/articles/optimizing-text-search-in-dax/ BECOME A CHANNEL MEMBER 🎉 ruclips.net/channel/UCjlfQwqb-0S40XQ8seYPLSwjoin CHECK OUT OUR MERCH STORE 👕 havens-consulting.creator-sprin...
Best Practices for Integrated Notes & Annotations in Power BI
Просмотров 2,2 тыс.Месяц назад
Learn about 6 locations to leave notes, comments, or annotations in Power BI desktop (PBIX) files. This approach covers notes both for report consumers, and model developers, tune in to learn more! RELATED CONTENT 🔗 Show DAX Expressions on Field Tooltips ruclips.net/video/Wkap4yZmO9M/видео.html Bookmark Notes ruclips.net/video/KFxrWuZZa78/видео.html BECOME A CHANNEL MEMBER 🎉 ruclips.net/channel...
Adding 3 or More Advanced Filter Conditions in Power BI
Просмотров 1,2 тыс.Месяц назад
Adding 3 or More Advanced Filter Conditions in Power BI
3 Report Configurations You Need to Review in Reader Mode!
Просмотров 7402 месяца назад
3 Report Configurations You Need to Review in Reader Mode!
Adding Integrated Bookmark Notes in a Power BI Report
Просмотров 1,3 тыс.2 месяца назад
Adding Integrated Bookmark Notes in a Power BI Report
Creating a Mult-Value KPI Scorecard with a Native Bar Chart ??
Просмотров 1,6 тыс.2 месяца назад
Creating a Mult-Value KPI Scorecard with a Native Bar Chart ??
Multi-Line KPI Data Labels for Native Visuals in Power BI !!
Просмотров 1,7 тыс.2 месяца назад
Multi-Line KPI Data Labels for Native Visuals in Power BI !!
Explosion Vs Erosion for Stacked Charts in Power BI!
Просмотров 7503 месяца назад
Explosion Vs Erosion for Stacked Charts in Power BI!
Turning Beast to Beauty: Removing Chart Junk in Power BI
Просмотров 1,2 тыс.3 месяца назад
Turning Beast to Beauty: Removing Chart Junk in Power BI
Dynamic Column Headers (with Field Parameters) in Power BI!
Просмотров 5 тыс.3 месяца назад
Dynamic Column Headers (with Field Parameters) in Power BI!
Five Tabular Editor 3 Hidden Tips for Power BI!
Просмотров 1,4 тыс.4 месяца назад
Five Tabular Editor 3 Hidden Tips for Power BI!
Creating a Dual Variance Chart w/ Overlap + Error Bars in Power BI
Просмотров 4,6 тыс.4 месяца назад
Creating a Dual Variance Chart w/ Overlap Error Bars in Power BI
Power BI Semantic Model Best Practices (PIMP) Script!
Просмотров 2,8 тыс.4 месяца назад
Power BI Semantic Model Best Practices (PIMP) Script!
(Case Study) Field Parameters or Calculation Groups???
Просмотров 2 тыс.4 месяца назад
(Case Study) Field Parameters or Calculation Groups???
Testing Your Code Using the [DAX] Query View!
Просмотров 1,8 тыс.5 месяцев назад
Testing Your Code Using the [DAX] Query View!
Avoiding HIDDEN Visual-Level Filters with Field Parameters
Просмотров 1,4 тыс.5 месяцев назад
Avoiding HIDDEN Visual-Level Filters with Field Parameters
Applying Custom Column Ordering for Field Parameters (Measures)
Просмотров 2 тыс.5 месяцев назад
Applying Custom Column Ordering for Field Parameters (Measures)
Identifying & Optimizing DAX Patterns (Case-Study)
Просмотров 1,4 тыс.6 месяцев назад
Identifying & Optimizing DAX Patterns (Case-Study)
Revisiting Common Calculation Group Patterns in Power BI!
Просмотров 2,3 тыс.6 месяцев назад
Revisiting Common Calculation Group Patterns in Power BI!
Improving Merging & Appending Power Query (Queries) with Ken Puls
Просмотров 1,9 тыс.6 месяцев назад
Improving Merging & Appending Power Query (Queries) with Ken Puls
IMPROVED - IBCS Styled Bullet Charts (SVG) in Power BI!
Просмотров 2,3 тыс.6 месяцев назад
IMPROVED - IBCS Styled Bullet Charts (SVG) in Power BI!
NEW Visualization Formatting & Data Label Updates! (with Miguel Myers)
Просмотров 6 тыс.7 месяцев назад
NEW Visualization Formatting & Data Label Updates! (with Miguel Myers)
Introducing PowerOps! (A NEW Productivity Tool for Power BI Developers)
Просмотров 7 тыс.7 месяцев назад
Introducing PowerOps! (A NEW Productivity Tool for Power BI Developers)
Automatically Rename CamelCase Columns in Power Query!
Просмотров 1,2 тыс.7 месяцев назад
Automatically Rename CamelCase Columns in Power Query!
Three Techniques for Curating the User Experience in Power BI!
Просмотров 1,9 тыс.7 месяцев назад
Three Techniques for Curating the User Experience in Power BI!
TIL: you can have subfolders in folders 😅
Needed!
What a neat effect! I'm not sure I will need it but you never know.
Exactly, an expert see's if the CAN do it, before asking if they NEED to do it 😅
NIce video! Personally I would reduce the data labels as you showed for min & max, but also include the first and last datapoint. Also, I think the area shade is too much extra ink in the visual. For the legend, I sometimes just grab a screenshot of the required legend and use that instead of an extra calculated visual, I feel it reduces the overhead.
Absolutely! I do show how to reduce the data labels for just min/max around the 9:40 mark. Start/End values are good ideas too, if you're going for that sparkline look. With anything it really boils down to what's most important for the users to look at :) It's why visual design is such a great combination of art and science 😁 I've found that screenshots of legends can end up being fuzzy and don't scale as well, making it more noticeable (to me) that it's an image, not a live rendering. But both work! Depending on the calc though, the visual container rendering could take a similar time. I ensure that any measure I use in the visual is cheap. Or even go as far as creating blank measures to use (hidden), so then there's 0 cost from the DAX perspective. ruclips.net/video/teX0hUqN370/видео.htmlsi=KXAtM2UwYfB-CrkF&t=578
How can i make this dynamic based on selected date from slicer?
Could you elaborate on what you mean by dynamic?
Gotta say, this video is gold. Delta Lake has some mystery around it and great when the magic is revealed. Can't wait to see the Storage Mode olympics!
Thank you for your video. I was struggling into finding a way to create a Scorecard in Power Bi and your video came to save the day!
Hey Reid, I just found out that it's possible to create Field Parameters with a Tabular Editor script, so you're not limited to only creating them in Power BI Desktop anymore. GIAC did a video demonstrating the technique back in January, and it's called "Can you use Field Parameters with Direct Lake in Power BI?": ruclips.net/video/Cg6zRhwF-Ro/видео.html
Heck yeah, thanks for that!
Nice workarounds for the quirkiness of the native PBI visuals! (too bad we have to do this often... 😑) You gave me some ideas for our current project. Thanks, Reid! 👍
Glad it was helpful! The new features from the #PBICoreVisuals team is really making it easier too
Nice video, thanks
Glad you liked it!
Love de graphics
Great presentation!
As a follow up, I tested C-GPT to optimize M code. Got one error message, copy/paste to C-GPT and the second version was perfect. And the additional comment lines are great as well
Can i show the last year sales too when i click the MTD and YTD Slicers, please need help here, kind of lost here, i have CY and LY sales in a separate table connected to a common calendar.
Some of my later videos in this series address that. Check the YT description for links to the follow up videos :)
@@HavensConsulting thanks a lot, i was kind of struggling here. The video is so helping. Thanks for the quicker response 😃
@@HavensConsulting i tried it but i got trouble getting the desired results, my 2023 and 2024 sales are located in different tables and i have connected those sales datas dates with calendar table. When i do this formula i am getting filtered only this year sales till date and last years disappear’s. How will i see last years sales from jan to till date along with current years. This is what i want. Need your assistance here 🥹.
Will existing JSON theme files to set visual defaults be compatible with the new PBIR format?
Fully supported. Currently this is just a folder and formatting restructuring. No changes to the actual JSON code are being made, so backward compatibility for custom theme files will work :)
Awesome, the seem like they would work hand in hand but wanted to make sure! Thanks for verifying!
What if I have 3 categories, can you help to solve this?
Not sure I'm following? Could you elaborate on the issue?
I'm able to get this to work in the desktop version. but finding that after publishing the report, the links in the webservice no longer follow the direct link. They're going to the site home page, rather than going to the direct page based on the concatenated link to the item. If I copy and paste the link to the web-browser, it works. if I click it, it doesn't.
Interesting, i've never seen that! Might be worth filing a bug on Microsoft using the ? icon in the upper right for this one
Great session! I am stoked what is yet to come. Especially seamlessly combining Visual Studio + Power BI desktop simultaneously together when creating / modifying / standardizing reports in the future. Amazing. Please Reid, keep us updated about this. And Thanks Rui and Eeshan.
Can you pull all the metric definition using this ?
Metric field definitions would be kept in the model layer. You could extract those via C# using Tabular Editor I'd figure :)
How should one can add 4 different colors in one gauge?
i have been struggling with this for the past two days... i kept making new queries, and it was cluttering up the project with all these "Parameters" i didnt want... i am so glad i found your video! i was pulling my hair out in frustration.
Glad it helped!
I need to develop a custom connector on top of ODBC/ system DSN. is there any material available that may help develop it.
Is there any way to debug the connector? I am finiding it really difficult to understand the flow and errors it throws and fix those. I don't have any prior experience in developing a power Bi custom connector.
There aren't many tools for debugging specifically. Custom connectors are custom enough that outside of RUclips videos like this there aren't many official courses. More experts to reach out to contract when help is needed, since not a lot of people need to build them
Great technique, Reid! Thanks for sharing! 🙏
My pleasure!
So nice of you to give credit to Bas! I enjoy following you both. And I also admire your clothing style btw
Thank you so much!
Do you can share with me the Dax code for spark line svg? 🙏 thanks I’m from Mexico City
If you go to our Blog Files page you can download the PBIX for free and get the code from there :) www.havensconsulting.net/blog-files
Reid, isn't best practice is to write SQL Query instead of checking whether Query will fold or not?
Native queries have their own complexities, and by default break any ability for Power Query to fold on top of it (more below) ruclips.net/video/DWbh7xp08l0/видео.html It also relies on having a developer know SQL and SQL optimization techniques, which are all built into the query folding engine. Like with most things though, it depends. :)
learning from you for free instead of my paid teacher... great Uni life I guess. Anyway, thank you!
Happy to help!
After installing Bravo and trying to attach it to Power BI Desktop, we encountered an issue: Bravo Power BI tool error 500 - the user does not have permission to access the Discover method. In the domain controller, what permissions does the user need to connect Bravo to Power BI?
Great question! I'd recommend reaching out to SQLBI directly on this one for support on their tool :)
I tried to do the same steps as in the video, it creates a pbiviz file, but when I want to import it in power BI, it says "the file "filename.pbiviz" isn't a valid custom visual". Any idea?
Not sure about this one, I tested again on a random PBIX I have with a custom visual (OKViz Sparkline), and getting the file from the inside zip and importing in another worked for me. What was the custom visual you were trying to extract?
Looks like a good "slide" if you work in consulting, doing report optimization (among other things).
Oh definitely. It works very well to show a before/after to any stakeholder, manager, or client when discussing results :)
What is so special about query folding? Why we should care about it? Incremental refresh works without query folding. Some folks say, it is quicker. But how can "Select * from Table1" writen by me (which does not fold) be slower than same thing written by the engine?
It's the magic sauce of Power Query :). Transformations are translated from M (Power Query) to the source, and passed back for the source to transform (faster). Rather than Power BI downloading the unprocessed data, and doing it itself (slower). You can easily get a 5, 10, 20+ times performance increase when the source database does most the work. A quick google search would give you some helpful results like below on why it makes queries faster. www.reddit.com/r/PowerBI/comments/14strbb/what_does_folding_in_query_folding_means/ Also, to note,. Incremental refresh is explicitly advised NOT to use without folding. Because without folding you download the entire data before filtering to the relative period. Which is why when folding can't be confirmed with the engine, it gives a big warning that advises not to use incremental refresh. More below on that as well. learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
@@HavensConsulting Thank you for your explanation. Are you saying if I write "Select ProductID from Sales" myself in the Source dialog Advanced options, Power Query still loads all the data first, then executes my Select statement?
@@1yyymmmddd native queries (e.g. writing custom SQL Code in the statement box) will actually break any ability to query fold. So generally advised to not use that. It's advised to use the Power query actions to choose your columns, filter your rows, do your transformations. etc. More info about native query limitations below learn.microsoft.com/en-us/power-query/native-database-query
Building on your idea. I made a tooltip page that was empty and sized 1 px x 1px. Now the tooltip is the triangle (pointer) and a tiny square.
Lovely as well!
good to know!
Cool trick.. 👌👌Thanks @Reid 😊👍
Excellent Reid!
Useful 👍
Wow, dbt with fabric. Thanks for sharing!
Nice video. Better you could zoom in the focused frames.
Nice👏
thanks for great video
What did you do to create the Window Key column in the field parameter table?
I used a DAX calculated column for that :) Window Key = SWITCH( TRUE(), '.Parameter - Dynamic Columns'[Parameter - Dynamic Windows Order] <= 2, 0, '.Parameter - Dynamic Columns'[Parameter - Dynamic Windows Order] <= 5, 1, '.Parameter - Dynamic Columns'[Parameter - Dynamic Windows Order] <= 8, 2 )
@@HavensConsulting Thank you so much! I'm trying to do something similar with a report I have, is there a reason why you used a different table for the window key, couldn't you just add directly the 1,2,3 of the month window size to the fields parameter table you already had?
Emgh where has this been all my life? Thanks for sharing! :)
You're so welcome!
Thank you for this insightful presentation. I have a question: I noticed that you were working with two fabric data warehouses, 100 and 200. It seems that your data is coming from data warehouse 100, and you are creating tables in data warehouse 200. In your profiles.yml file, you added the host from the destination warehouse 200. My question is: Where did you add the host/sql endpoint from the source data warehouse 100? I'm a bit confused here! Thanks. I would like to try myself on my current Fabric Trial!
In Fabric, so long as you have permissions, you can cross-query across Lakehouses/warehouses from a single SQL Endpoint. So you're right, my data is stored in the 100 Lakehouse, but I'm creating my new tables in the 200 Warehouse. I'm still able to query the 100 LH from the 200 WH using the single 200 connection string in my dbt profile. Although it's not an essential step, I also declared/aliased my source tables in a sources yml file so I could maintain lineage to the source tables. Hope that helps.
@@johnnyw5627 Great! I am also testing Fabric now with an Azure trial account. Do you think that I have enough permissions for this cross-query Lakehouse/warehouse scenario? So 100 is not a DWH but it is a Lakehouse! Mind blowing... Do you have a repo for this example we can check? Thanks Johnny!
Thank you for your replay.❤ Permissions.. hmmm, with free trial!!! This is really cool what you did there with 100 lakehouse and 200 warehouse... I am really curious to see you .profiles and dbt_project files to see how it is done! (Github?)
For folks asking, there's a repo here: github.com/GreyskullAnalytics/by-the-power-of-analyics-engineering
@@johnnyw5627 Thanks Johnny!
Urra!!!!!
Cool hack brother. Nice find!
Thank ya! Though I try to avoid a "hack" or "trick" term, especially if it's uncovering a native hidden feature that doesn't break anything. Hacks to me would be more like layering two visuals to make it look like one visual, etc. Anything with a downside basically as a cost to the hack.
Power BI will no longer allow me to create the relationship due to circular dependency. How can I fix this?
There's a video link in the description of this video that should solve that issue for you. Part 5 of this series :)
@@HavensConsulting Thank you, that worked.
Would have been great if you had gone into greater depth on pagination. That is probably the 2nd hardest (maybe 1st) concept to learn when calling API's.
hey Alex, thanks for the shout out! Always happy to see more folks talking about Databricks and Power BI together.
We have setup a system that gets all our metadata from all our reports (over 200) in production by leveraging the INFO. Dax function using along side the powerBI API running on SSIS with powershell back into SQL. We get the column/measure names descriptions, data type, relationships and pretty much everything we need. Then crushing the data in SQL, we build our data model of our metadata in one single powerBI, then filter this PowerBI with RLS, embedding it in sharepoint for our 30000+ organization. This way, we have a solid and « really » efficient way to document everything, update it and make it accessible.