fbpx

About pleblanc

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

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

Are you following best practices with Azure Synapse Analytics?

How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It's a great way to get an understanding where your database is at! Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-analyzer-report-to-monitor-and-improve-azure/ba-p/3276960 Download [...]

Are you following best practices with Azure Synapse Analytics?2022-05-14T15:14:25-05:00

How do you share your Power BI Dataset for someone to review?

Need to have someone review your Power BI dataset for best practices and approval? Don't want to send them the full Power BI Desktop file and risk sharing data? Patrick walks you through some options that you have.

How do you share your Power BI Dataset for someone to review?2022-05-12T06:25:46-05:00

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
Go to Top