My Power BI guest blog posts

My GKCCF cubicle with painting, Sign of Spring by Karen Kaffenberger

I collected some blog posts which I published on the P3 Adaptive blog. Many of them are workarounds. Some things are dated and there may be better ways to do them now. You can see my focus on data governance and enterprise issues over the years.

Personal

• English Major to Data Analyst: DAX, Power Query, Power BI (p3adaptive.com)

  • a couple of things about how I got into data

Data Governance and Enterprise Data Warehouse

• So, You’re Getting a Data Warehouse for Power BI…

  • part of a long history of me trying to wrangle artifacts from EDW into a simple star schema

• Slowly Changing Dimension SCD Power BI Lookup table data warehouse (p3adaptive.com)

  • one attempt to work with SCD2 in Power BI. For some cases, you need to move a historical value onto the fact table instead

• How Do You Know Your Power BI Security Roles are Right? - P3 (p3adaptive.com)

  • automate the auditing of row-level security

• Automated Testing With Power Query - P3 Adaptive

  • if something is wrong with the refresh, force it to fail

• Power BI Workspaces, Apps & Keeping changes from disrupting reports (p3adaptive.com)

  • using SharePoint to automate updates. This is a Power BI Pro solution, which is not as robust as Premium Deployment Pipelines

• How to Get Power BI Service to Work for You

  • more details on the SharePoint solution

Workarounds and miscellaneous hacks

• DST Refresh Date Function Power BI Service-daylight-savings-time (p3adaptive.com)

  • if you haven’t had to wrestle with DST issues, then I’m happy for you…

• Power Query (M)agic: Parameters for Dataflows!

  • when you use dataflows as a source in Power BI, the automated steps reference the dataflow internal id, which is a problem if you need to replace a dataflow. This helps future proof dataflows for this kind of change

• Visualizations in Power BI Dashboard. Layered visuals; image tiles. (p3adaptive.com)

  • forgot about this one. A clever workaround for pinning layered visualizations to a Power BI dashboard artifact in the Power BI service.

• Export Power BI Data with Date Range in Title - P3 Adaptive

  • conditional title when exporting a table to Excel. A nice usability hack

• Trailing Twelve Months TTM Power BI, Prior TTM, Variance, DAX (p3adaptive.com)

  • Use a disconnected table in Power BI to show each month and total trailing twelve months (TTM), the total for prior TTM, AND the variance between the two in one matrix table.

• DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1) - P3 Adaptive

  • using what-if parameters to give the report consumer control

• DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)

  • this uses a table to create a kind of custom reporting structure