Power BI usage scenarios: Self-service data preparation - Power BI
Learn how Power BI self-service data preparation is about using dataflows to centralize data cleansing and transformation work.
Power BI
BI Framework
Charticulator Visual
Creating custom visuals using the Charticulator in Power BI is not easy. So here are some some Charticulator resources I've used to skill up.
Data Visualization
Thin Reports, Report Level Measures vs Data Model Measures - Thin Reports, Report Level Measures vs Data Model Measures
This post explains what report level measures are, when, and how we can use them in a Power BI thin report.
Mastering DP-500 Exam: Performance improvements in queries and visuals! - Data Mozart
Finding the main bottleneck in your Power BI report may be a challenging task. Learn how to quickly identify the poor performing report elements and how to improve the overall performance by applying some clever tricks!
DAX
Power BI: Divison wanted - my German ‘Bezirksliga’ suggestion
Hey folks, if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.
Power Query
Normalizing conditional formatting bars
Normalizing conditional formatting bars in Power BI is not easy, but can be done with a measure and a calculation group. No more bars covering the values.
Power BI usage scenarios: Enterprise BI - Power BI
Learn how Power BI enterprise BI is about organization-wide content distribution at scale.
Power BI usage scenarios: Customizable managed self-service BI - Power BI
Learn how Power BI customizable managed self-service BI is about creating new specialized datasets by extending and personalizing existing datasets.
managed self-service BI is characterized by a blended approach that emphasizes discipline at the core and flexibility at the edge.
However, when the core data architecture doesn't include all data required, dataset creators can extend, personalize, or customize existing shared datasets. New specialized datasets can be created that meet business requirements not met by existing centrally delivered datasets. Importantly, there's no duplication of core data. This usage scenario is called customizable managed self-service BI.
Sometimes self-service creators need to augment an existing dataset with, for instance, additional data that's specific to their department. In this case, they can use DirectQuery connections to Power BI datasets
This feature allows for an ideal balance of self-service enablement while taking advantage of the investment in centrally managed data assets. The scenario diagram depicts a DirectQuery connection
Power BI usage scenarios: Managed self-service BI - Power BI
Learn how Power BI managed self-service BI is about reuse of centralized shared datasets by other report creators.
Usually, there are many more report creators than dataset creators. These report creators can exist in any area of the organization. Because self-service report creators often need to quickly produce content, a blended approach allows them to focus on producing reports that support timely decision-making without the additional effort of creating a dataset.
The primary objective is for many report creators to reuse centralized shared datasets. To accomplish that, this scenario focuses on decoupling the model development process from the report creation process.
For simplicity, the scenario diagram depicts just one shared dataset. However, it's not usually practical to model all organizational data in a single dataset.
The other extreme is to create a new dataset for every report, as less experienced content creators often do. The goal of managed self-service BI is to find the right balance, leaning toward relatively few datasets and creating new datasets when it makes sense to do so.
hile reports are maintained by subject matter experts in the business units. However, that's not required. For example, this pattern can be adopted by any content creator that wants to achieve reusability.
(8) A Power BI Gateway Monitoring & Troubleshooting Solution | LinkedIn
One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters. Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in t
Dimensions of Self-Service in Power BI: Part 1 — DATA GOBLINS
In this post, I write about the options for self-service tooling in Power BI. Which tools to use for which cases, by whom & why? I've found it's helpful to visualize the different dimensions of this, to know the options & understand user skill/solution paths.
Dimensions of Self-Service in Power BI: Part 2 - The Dimensions of Learning — DATA GOBLINS
In this post, I write about the learning paths users take when using self-service solutions in Power BI. Specifically, I illustrate a way to conceptualize these learning paths, making it easier to segment users and create meaningful training programs.
1 Client ID, 1 Secret and a Bearer token in Power BI
Connecting to data sources in Power BI can be very easy. But when you need to call three end points to get to your data with Secrets, Client IDs and Bearer
How to Trigger a Power BI Dataset Refresh via Azure Synapse Analytics in 3 Simple Steps. | Purple Frog Systems
In this blog post we'll explore how to trigger a Power BI Dataset via Azure Synapse Analytics in 3 simple steps: Step 1: Create a new security group called “AzureSynapsePowerBIIntegration” in your Azure Active Directory. Next add the name of your Azure Synapse Workspace as a member of your new security group. This will be
Power BI - Service
Chris Webb's BI Blog: Monitoring Power Query Online Memory And CPU Usage
Power Query Online is, as the name suggests, the online version of Power Query – it’s what you use when you’re developing Power BI Dataflows for example. Sometimes when you’…
Exporting Power BI data with "Run DAX query against dataset" action in Power Automate
With lo-code we can automate exporting data from Power BI visuals without any REST API knowledge. We need simply copy DAX queries from “Performance Analyzer”, past it in Power Automate inside “run a query against dataset” action . Then we can perform export operation according to our requirements.
Documenting Power BI – Data model V2 – Now with VertiPaq included - Self-Service Business Intelligence
Expanding the documentation capabilities for a Power BI data model with additional attributes and Vertipaq information.
Using Tree Map as legend on a page in Power BI - Prathy's Blog...
I recently worked on two projects where the client wanted to show multiple metrics sliced by the same categorical data. For example, seeing how various metrics are performing over different…
How to Get DAX Query Results Out of Power BI… Without Writing Any DAX or Code
Power BI’s DAX language is often described as “simple but not easy.” While visuals such as tables and matrices generate a lot of DAX behind the scenes, such as subtotals and total…
Compare two tables from different sources thoroughly
When migrating processes you need to compare the outputs thoroughly. Power Query is a great tool to build such comparisons as you can refresh from the source.
Release Power BI Notebooks v1.5.0 · samaguire/PowerBINotebooks
Notebooks Async Refresh Uses PowerShell to connect to the Power BI Service and trigger a customised dataset refresh using the Power BI API. Add Calculation Group Uses PowerShell to connect to an An...
Switching columns and rows in a Power BI matrix visual with Field Parameters
If we want to make a dynamic disposition of fields in a matrix and give the user the possibility to select the order in which he can display the fields in rows or columns, we can use the Field parameters feature to achieve this goal. Here are the steps to configure it:
Filter a Power BI report passing parameters through URL - LazySnail
Power BI offers us a very sympathetic way to bring a bit more flexibility into our Reports. It’s not a brand-new feature, but I’m not sure that you know it! You can display a report and automatically have a page filtered by the parameters you define in the URL. Why is it cool? We can […]
“Out of One, Many”, or: Making Switchable Charts in Power BI with Deneb
When Personalize Visuals is too personalized: an experiment in switching displayed charts using a dimension attribute.
Tabular Editor 3.3.0 | Tabular Editor Documentation
Using Field Parameters when connecting to a #PowerBI dataset or Azure Analysis Services
The new preview feature “Field parameters” in Power BI desktop has opened a lot of creativity in the Power BI community. But if you use a connection to a Power BI dataset or Azure Analy…
Chris Webb's BI Blog: Cancelling Power BI Dataset Refreshes With The Enhanced Refresh API
The most exciting (at least for me) feature in the new Enhanced Refresh API (blog announcement | docs) is the ability to cancel a dataset refresh that’s currently in progress. Up until now, a…
Field Parameter and Bookmarking Field Parameter Values In Power BI Report Server
What is Field Parameters? Power BI service in May 2022 released the Field Parameters feature. As explained in the Microsoft site... "Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and cus...
Field Parameters in Power BI
Scenario: The May 2022 version of Power BI Desktop includes a very interesting and useful feature – Field Parameters. To better help you understand this new function, I would like to generally introduce it and share with you about some common application scenarios. Introduction Field: a table colu...
Using SELECTEDVALUE with Fields Parameters in Power BI - SQLBI
If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calc