Need some help optimizing your Power BI Dataset but don't want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY! DAX Studio https://daxstudio.org/ Bravo for Power BI https://bravo.bi/ Tabular Editor 3 https://tabulareditor.com/
Have you noticed some extra queries being sent when using Incremental Refresh in Power BI? Patrick explains why this could happen and a potential workaround. Privacy Levels: https://docs.microsoft.com/power-bi/enterprise/desktop-privacy-levels
Here is another 30-day Query Folding challenge video for you. Patrick takes on Day 7 and ramps up his Power Query knowledge! Will Power BI Desktop get the best of him??? GitHub Repot: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY
Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can't be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/
Column From Examples, in Power Query, keeps blowing our mind! Patrick shows you an example where he wanted to extract some data. Will Column From Examples work? Of course, it will! Check this out! Add a column from examples in Power BI Desktop https://docs.microsoft.com/power-bi/create-reports/desktop-add-column-from-example
Do you use a central date table for your Power BI datasets? There is a LOT of POWER in having one. Adam shows you different ways to create one including a really simple easy option that's BANANAS! REDUCE Power BI dataset size by 60% with ONE CHECKBOX??? https://www.youtube.com/watch?v=RnDdDlozcdo Bravo for Power BI https://bravo.bi
Answering one of your Power BI questions about how to prevent data in a visual if nothing is selected in a slicer! Challenge accepted! Do's and Don't with cascading slicers in Power BI https://www.youtube.com/watch?v=1yv5srlqgmI
When using composite models in Power BI, you have a choice for how to store your tables. Storage mode gives you options, but why would I pick one versus the other for my dimension tables? Adam has you covered! Use composite models in Power BI Desktop https://docs.microsoft.com/power-bi/transform-model/desktop-composite-models DirectQuery model guidance in Power BI Desktop https://docs.microsoft.com/power-bi/guidance/directquery-model-guidance
Want a custom message or title in your Power BI report? Not happy with the formatting options of the card visual or buttons? Patrick shows you a way that can be fully customizable!
Working with more data than you can use in Power BI Desktop on your machine? Patrick has a trick for you to work with the subset of data locally and all the data in the service without using Premium!
