Objects tagged with power-bi


← Back to the Posts

Add Dynamic Role Level Security to PowerBI Using an Attribute of the Current User

Published on March 21, 2018 at 02:09AM

Take the currently logged in user in PowerBI and filter data based on an attribute of the User table

Add Dynamic Role Level Security to PowerBI using current users email

Published on March 08, 2018 at 11:07PM

Users logged into PowerBI can have their email address exposed. This allows us to create dynamic row level security using inner joins on a user table.

Create a Simple Empty Table in Power Query with Code Example

Published on December 14, 2017 at 06:23AM

Just copy and paste this into a blank query and you will get a simple two column table with two rows.

Add a Date Model to PowerBI or Power Query

Published on December 08, 2017 at 12:10AM

I regularly add a model to my Power BI or Power Query to represent the date and functions around date.

Writing a Blog Post About M Lang/M Language/Power Query Formula Language/Power BI/Get & Transform

Published on June 21, 2017 at 12:51AM

Informally Known As WTF is M

Connect PowerBI to a Remote PostgreSQL Database Encrypted with SSL

Published on June 20, 2017 at 10:55AM

You read the brochure but you just can't get that hot tub workin'

Simple Power Query M to Display When the Report was Last Refreshed

Published on May 17, 2017 at 12:39AM

Very simple query to show when you last hit the 'Refresh' button in PowerBI

Display a SQL Server Table Schema in PowerBI

Published on May 03, 2017 at 04:33AM

This was useful when building a subsequent M Query and needed to know all available table column, types and keys

Turning On Fast Combine in Power BI to enable Personal Gateway Data Refresh

Published on April 05, 2017 at 04:53AM

Fixing bugs like "We cannot convert the value "[Table]" to type Table."

Tiny Tweaks Needed for the Power Query Editor

Published on March 20, 2017 at 12:33AM

A collection of the issues I run into day to day using the Query Editor along with the magic sauce to make it better

Implementing an Environment Parameter in Power BI to Improve Performance in Development

Published on March 06, 2017 at 06:18AM

Limit the amount of time you watch Power BI getting rows of data when you are working on your views

Managing Queries in PowerBI and Power Query using Git

Published on March 01, 2017 at 12:54AM

Backing up and using version control systems are real things we should consider to save us from that next crash that is likely to occur

SumIFS in Power BI DAX Using Current Row Value as Filter

Published on February 23, 2017 at 07:22AM

Simply sum the quantity using a field from the current row as a filter in the table you are summing from

CountIF in PowerBI DAX

Published on February 23, 2017 at 07:21AM

Simply Count the

Add a DateKey Column in PowerBI M Lang

Published on February 21, 2017 at 01:18AM

Date's can get difficult to merge on other date or datetime fields. Use this function to convert to a DateKey or Date ID

Loading M Queries from the Web into Power BI

Published on February 15, 2017 at 04:08AM

Reuse your code by pulling queries from web servers

Single and Multi Line Comments in Power Query Advanced Editor

Published on February 13, 2017 at 11:01AM

Just a simple reminder on how to do single and multiple line comments

Countif in Power Query or Powerbi using M Language

Published on February 13, 2017 at 10:57AM

You know how to countif in Excel so why is Power Query so difficult?


← Back to the Screenasts
There are no casts tagged with power-bi