fbpx

About pleblanc

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

Unboxing Tabular Editor 3 | Reaction Video

It's here! Patrick does a reaction video when using Tabular Editor 3 for the first time with Power BI. To say he's excited is an understatement. Watch him take the wrapping off of Tabular Editor. Tabular Editor: https://tabulareditor.com/

Unboxing Tabular Editor 3 | Reaction Video2021-06-16T05:27:10-05:00

Exploring ANOMALY detection in Power BI and a SNEAK PEAK

Looking for ANOMALIES in Power BI? Justyna Lucznik walks Patrick through the new anomaly detection in Power BI and gives a SNEAK PEAK at what's coming! Anomaly detection: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-anomaly-detection

Exploring ANOMALY detection in Power BI and a SNEAK PEAK2021-05-26T05:17:13-05:00

A TWIST on dynamically filtering visuals by a slicer in Power BI

Here's a twist on dynamically filtering visuals by a slicer in Power BI! You can't use a measure directly in a slicer, so here's a way to get a similar experience and maintain usability of your reports. Scott Sewell: https://twitter.com/scottsewell BI Elite Video: https://www.youtube.com/watch?v=AZAL-QPn5Zc

A TWIST on dynamically filtering visuals by a slicer in Power BI2021-05-19T05:51:02-05:00

Test your Power BI DAX measures in DAX Studio

Learn how to get your DAX measures in working order, using DAX Studio, before putting them in your Power BI report. Patrick walks you through it! SQLBI article: https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/ Hiding Future Dates video: https://www.youtube.com/watch?v=VXd1wl-5vKI

Test your Power BI DAX measures in DAX Studio2021-05-12T06:26:53-05:00

Enable QUERY FOLDING for native queries in Power Query / Power BI

We have usually said that if you use a native query, you break query folding in Power Query. Interesting. There may be a way to enable it in Power BI! Patrick shows you how. Chris Webb Blog: https://blog.crossjoin.co.uk/2021/02/21/query-folding-on-sql-queries-in-power-query-using-value-nativequery-and-enablefoldingtrue/ Query folding guidance in Power BI Desktop https://docs.microsoft.com/power-bi/guidance/power-query-folding Visualise your Power BI Refresh https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/

Enable QUERY FOLDING for native queries in Power Query / Power BI2021-05-06T04:43:14-05:00

Avoid Left Outer Joins with DirectQuery in Power BI

By default, your DirectQuery queries, in Power BI, will send a LEFT OUTER JOIN and could make your DBA not happy! Patrick shows you how you can change this to an INNER JOIN and put your DBA back into that happy space.

Avoid Left Outer Joins with DirectQuery in Power BI2021-05-05T06:41:33-05:00

Report BURSTING with the Power Platform

Automate data driven subscriptions with the Power Platform using Power BI and Power Automate! Patrick shows you how to quickly setup a report bursting option for your reports.

Report BURSTING with the Power Platform2021-04-28T03:50:38-05:00

Power BI for the NON-TECHnical person

Is Power BI intimidating? Coming from Microsoft Excel? You consider yourself non-technical? Don't want to have to write or know anything about DAX? Patrick looks at how you can create a report quickly with just your Excel data and not have to write any code!

Power BI for the NON-TECHnical person2021-04-08T06:40:01-05:00
Go to Top