fbpx

About pleblanc

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

Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!

Hybrid Tables can be very useful for mixing archived data with current data. Pat Mahoney joins Patrick to show how to configure a Hybrid Table within a Power BI dataset without using Tabular Editor. Just some straight "M"agic. Hybrid Table Documentation: https://learn.microsoft.com/power-bi/connect-data/service-dataset-modes-understand#hybrid-tables Connect with Pat Mahoney: https://twitter.com/mahoneypa https://www.linkedin.com/in/patrick-mahoney-3138526/ https://www.youtube.com/@hoosierbi5669 https://hoosierbi.com/

Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!2023-04-05T08:43:57-05:00

Checking out the new Power BI RLS Editor

Take a look at the new Row-Level Security (RLS) editor within Power BI Desktop! Patrick explores how it works and what to look out for in the Preview. Power BI February 2023 Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/ Documentation https://learn.microsoft.com/power-bi/enterprise/service-admin-rls#define-roles-and-rules-in-power-bi-desktop-using-enhanced-row-level-security-editor-preview

Checking out the new Power BI RLS Editor2023-03-22T08:21:51-05:00

What’s a JUNK DIMENSION and when should you use it?

Maybe you've heard of the concept of a junk dimension but what exactly is it and when should you use it? Patrick breaks down this dimensional modeling concept. Junk Dimensions https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/junk-dimension/ Design Tip #113 Creating, Using, and Maintaining Junk Dimensions https://www.kimballgroup.com/2009/06/design-tip-113-creating-using-and-maintaining-junk-dimensions/ Sample Script: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230321%20-%20Junk%20Dimension.sql

What’s a JUNK DIMENSION and when should you use it?2023-03-22T08:25:13-05:00

Getting Crazy with the Power Query UI

Using Merge statements? Alex shows you how that can break the fold in Power Query! He's got you covered though and shows you a different way to approach it to make folding work! Using the UI! Alex Powers: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ https://itsnotaboutthecell.com/

Getting Crazy with the Power Query UI2023-03-01T09:05:52-05:00

How to get a CLOCK in your Power BI Report

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen! Vega Clock Sample https://vega.github.io/vega/examples/clock/ HTML Content Custom Visual Limitations https://www.html-content.com/reference/limitations Kerry Kolosko https://kerrykolosko.com/exploring-deneb-for-power-bi/

How to get a CLOCK in your Power BI Report2023-02-22T09:22:25-05:00

Checking out the Window Clause in Azure SQL and SQL Server 2022

Partitioning is nice in SQL, but how about using the WINDOW clause to make it more efficient? Patrick looks at how to use this function with Azure SQL and SQL Server 2022! SELECT - WINDOW - (Transact-SQL) https://learn.microsoft.com/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16

Checking out the Window Clause in Azure SQL and SQL Server 20222023-02-21T08:52:21-05:00

Publish/Migrate your RDL files from Power BI Report Server to the service

Using on-premises Power BI Report Server? You can now migrate your paginated RDL reports to the Power BI service from within the portal. Patrick shows you how! Plan to migrate .rdl reports to Power BI https://learn.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi Blog Announcement: https://powerbi.microsoft.com/blog/power-bi-report-server-january-2023-feature-summary/#post-21998-_Toc121395751 Public RDL files to Power BI https://learn.microsoft.com/power-bi/guidance/publish-reporting-services-power-bi-service?tabs=powerbi-report-server

Publish/Migrate your RDL files from Power BI Report Server to the service2023-02-15T07:20:36-05:00

Provide data lake access with Azure Synapse Analytics

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what's missing! Azure Synapse Access Control https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview How to set up access control for your Azure Synapse workspace https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control Control storage account access for serverless SQL pool in Azure Synapse Analytics [...]

Provide data lake access with Azure Synapse Analytics2023-02-14T08:02:43-05:00

Time to look at the new INDEX function in DAX and Power BI

The latest DAX functions in Power BI can be very "power"ful! Patrick starts by looking at the INDEX function to solve a customer problem! Blog announcement: https://powerbi.microsoft.com/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731 INDEX function (DAX) https://learn.microsoft.com/dax/index-function-dax WINDOW function (DAX) https://learn.microsoft.com/dax/window-function-dax Chris Webb's Blog https://blog.crossjoin.co.uk/2023/01/02/why-dax-window-functions-are-important-for-performance-in-power-bi-directquery-mode/ Jeffrey Wang's Blogs on Window Function https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/ https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/

Time to look at the new INDEX function in DAX and Power BI2023-02-08T09:15:44-05:00
Go to Top