fbpx

From Decomposition Tree to Details in Power BI!!!

The Decomposition Tree is an amazing visual but how can we get to the details. Where's my drill through? Patrick walks you through how you can set this up in Power BI Desktop! Create and view decomposition tree visuals in Power BI https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-decomposition-tree Set up drillthrough in Power BI reports https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough Wyn Hopkins https://twitter.com/wynhopkins

From Decomposition Tree to Details in Power BI!!!2022-06-22T09:03:00-05:00

Publish from Power BI Desktop for External Users

Have you ever wanted to publish from Power BI Desktop to a different organization? External Users publishing!!! Adam shows you how you can log in as an external user in Power BI Desktop and then publish. BANANAS!!! Ross Couldrey LinkedIn: https://www.linkedin.com/in/rosscouldrey/ Distribute Power BI content to external guest users using Azure Active Directory B2B https://docs.microsoft.com/power-bi/guidance/whitepaper-azure-b2b-power-bi

Publish from Power BI Desktop for External Users2022-06-16T07:55:32-05:00

What tool do you use to optimize your Power BI dataset?

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/

What tool do you use to optimize your Power BI dataset?2022-06-15T07:54:00-05:00

Reduce the queries being sent with Incremental Refresh in Power BI!

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

Reduce the queries being sent with Incremental Refresh in Power BI!2022-05-26T07:18:26-05:00

Another 30 Day Query Folding challenge!!!

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

Another 30 Day Query Folding challenge!!!2022-05-18T09:20:00-05:00

Row-Level Security and Object-Level Security together in Power BI??? Yup!

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/

Row-Level Security and Object-Level Security together in Power BI??? Yup!2022-04-27T05:20:32-05:00

Blown AWAY by Column From Examples in Power Query

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

Blown AWAY by Column From Examples in Power Query2022-04-20T06:41:48-05:00

How to get a DATE TABLE easily in Power BI

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

How to get a DATE TABLE easily in Power BI2022-04-14T07:04:44-05:00

Nothing selected in Power BI Slicer? Then don’t show data!

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

Nothing selected in Power BI Slicer? Then don’t show data!2022-04-07T06:04:05-05:00
Go to Top