fbpx

About pleblanc

This author has not yet filled in any details.
So far pleblanc has created 204 blog entries.

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion! DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/ Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???2022-05-11T06:40:26-05:00

How to make SQL Pools even faster in Azure Synapse Analytics

There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools. Performance tuning with materialized views using dedicated SQL pool in [...]

How to make SQL Pools even faster in Azure Synapse Analytics2022-05-10T06:23:35-05:00

Why you should look at Azure Synapse Analytics!

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It's so much more than SQL Server! Adam and Patrick look at why you should care about it! What is Azure Synapse Analytics? https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

Why you should look at Azure Synapse Analytics!2022-05-03T05:43:46-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

Demystifying Custom Partitions in Power BI

We talk about Incremental Refresh a lot, but what if you need custom partitions in Power BI? How do you even create those? They look scary! Patrick takes the mystery away and walks you through how you can create them. Partitions in tabular models https://docs.microsoft.com/analysis-services/tabular-models/partitions-ssas-tabular

Demystifying Custom Partitions in Power BI2022-04-21T07:10:14-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

Are you backing up your Power BI Dataset???

While Power BI is a SaaS service, backing up your dataset is still important. What if something was accidently deleted? How do you recover it? Patrick shows you how you can get a backup / restore process in place so you can sleep at night. Backup/Restore PowerShell Script: https://guyinacu.be/backuprestorescript Backup and restore datasets with Power [...]

Are you backing up your Power BI Dataset???2022-04-13T06:50:37-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