Power BI Reports Catalog – Build yourself | Data Awareness Programme

Power BI
Michael Kovalsky on LinkedIn: Release Report Analyzer 1.2.0 · m-kovalsky/ReportAnalyzer
Make sure to download version 1.2.0 of #reportanalyzer which has just been released! Several UI enhancements have been made as well as adding the ability...
How to do Linear Regression in Power BI
In this tutorial, interact with a Power BI dashboard that walks through how to do linear regression in Power BI.
Chris Webb's BI Blog: Setting SQL Server CONTEXT_INFO In Power Query
In my quest to check out every last bit of obscure Power Query functionality, this week I looked into the ContextInfo option on the Sql.Database and Sql.Databases M functions. This option allows yo…
Analyst 2.0
The newest generation of analysts is about to change the game.
Power BI Advanced Export Options for Paginated Reports | Data Awareness Programme
Implementing Object-level Security in Power BI - Visual BI Solutions
Object-level security (OLS) enables you to restrict access to objects in Power BI, which includes tables and columns.
Power BI Icon Names for Conditional Formatting Using DAX
Get the list of default icon names in Power BI for conditional formatting and learn how to use it in a DAX expression
Power BI Get Data from Google Sheets
Learn how to get data of a Google Sheet loaded into Power BI using the Power Query Google Sheet connector with some details
Creating Power BI Premium Per User or Premium Partitions with Tabular Editor - Reporting/Analytics Made easy with FourMoo and Power BI
In this blog post I show how to use tabular editor with Power BI premium per user or premium to quickly create partitions.
Configure Incremental Refresh with Tabular Editor - Guy in a Cube
Need to configure Incremental Refresh but don’t have access to the Power BI Desktop file? No problem! Patrick shows you how to set things up with Tabular Editor.
Power BI Bookmark Navigator – A Better Hack – Prologika
Power BI bolsters Azure AS compatibility with EffectiveUserName support
We are announcing support for user impersonation using the EffectiveUserName connection-string property. This is truly exciting because it opens the door for mass migrations of tabular Analysis Services solutions that rely on EffectiveUserName-based impersonation to Power BI. It also opens new options for administrative tools and scripts to connect to datasets on Power BI Premium using different user identities! Impersonating another user can be as easy as specifying that user’s UPN on the connection string.
Announcing Power BI integration with Databricks Partner Connect
Power BI Desktop customers can now visualize data in their Delta Lake using Databricks with just a couple of clicks. In the past, connecting to Databricks from Power BI Desktop required the end user to perform a lot of manual configuration. Power BI Desktop integration with Databricks Partner Connect makes it simple to connect to your Delta Lake so you can start doing analytics and sharing insights with your business.
Capacity settings for datasets are now in Power BI Premium Gen2
Capacity settings for datasets now in Power BI Premium Gen 2!
SWITCH and SWITCH(TRUE... in Power Query
This blog post provides a close equivalent of the DAX's SWITCH function in Power Query, which addresses the SWITCH(TRUE... usage.
Power BI Goals - How to Implement Series - Marquee Insights
This series start discusses why Power BI Goals are a great fit for those new to Power BI and what three key decisions are needed.
The Universal Data Consolidator
Learn about the Universal Data Consolidator in this guest blog post by Sameer Bhide!
Calculate weighted average in Excel PivotTable in 2 ways - Data Cornering
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX that can be used in Power BI.
How to use List.Generate to make API Calls in Power Query M - Gorilla BI
Learn how to use List.Generate in Power Query to loop through APIs. Repeat API calls until your condition is false. Works with pagination!
List.Generate in Power Query: Tutorial with Easy Examples - Gorilla BI
List.Generate is an advanced Power Query function that creates lists. It allows you to implement iterations and has similarities with loops.
Chris Webb's BI Blog: Power BI/Power Query Data Privacy Settings And Errors Caused By Nested Values
Over the past few years I’ve blogged and presented extensively on the subject of Power Query’s data privacy settings (see here for a post with links to all this content). I thought I kn…
Analyzing the parallelism of storage engine operations in DAX Studio - SQLBI
This article describes the improved server timings features in DAX Studio 2.17 to analyze the parallelism of storage engine operations. When you execute a D
How to enable the Single Value option in a Power BI slicer - SQLBI
This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. When creatin
Create Connected PivotTables in Excel for the web
You can now create reports connected to Power BI datasets from a blank workbook in Excel for the web.
Welcome to Action BI Toolkit | Action BI Toolkit
Action BI Toolkit - SQLBI
Action BI Toolkit provides tools to bring Power BI projects under source control, enabling professional development workflows and enhanced governance. Avail
How did I keep my Power BI dataset measures documented and up to date? - Reporting/Analytics Made easy with FourMoo and Power BI
In this blog post I show how to use Power BI to document all the measures in my Premium Per User/Premium datasets.
Power BI Formal vs. Self-Training -
Which method is better for Power BI? Formal vs Self-Training. Will one accelerate your skill faster?
What are those new buttons under tab order in Power BI?
If you’ve visited the Tab order area of the Selection Pane in Power BI in the last couple of months, you might have noticed some new buttons. Three new buttons for managing tab order in Power…