Mind the Gap

Power BI
Automatically plug or balance your balance sheet in Power BI –
Learn how to automatically balance the balance sheet in Power BI. Bookkeeping doesn't contain PnL bookings yet? Planned figures don't add up?
Dynamic what-if with user-entered data in Power BI
Create a what-if parameter in Power BI based on end user inputted values
Power BI Usage Metric Reporting: A Guide to Game-Changing Insights - P3 Adaptive
Power BI Usage Metrics Report If you build it, they will come. That movie line doesn’t just fit baseball diamonds, it is often uttered when an
Demystifying Power BI Dataset Scale-out – Prologika
Empower your application users to quickly explore their data with the new Power BI Embedding capabilities
We’re excited to announce a new form of Power BI embedded analytics that enables you to embed an interactive data exploration and report creation experience in your applications. With this solution, you’ll be able to provide your users a similar experience to our integrations in Dynamics 365 and SharePoint.
Announcing Availability Expansion of the SSRS Migration Tool to Power BI
The SSRS RDL Migration tool is now available in SSRS 2017, SSRS 2019 and SSRS 2022! You can also migrate .pbix and .rdl files from Power BI Report Server January 2023 and Report Server September 2022.
Power BI Activity Logs: New Workspace Metadata for Excel Scenarios
We are announcing improvements to the Power BI audit logs that helps Power BI admins filter usage of Power BI data in Excel by workspace name and workspace id.
On-premises data gateway February release
It’s our first on-premises data gateway release of 2023! Note that beginning on March 15, 2023, any Power BI dataflow using an on-premises data gateway version older than April 2021 might fail. To ensure your refreshes continue to work correctly, be sure to update your gateway to the latest version.
Power BI migration tools: what they can and can't do
Beware of Power BI migration tools that do things that are unsupported or over-promise
How Charts Work: Understand and explain data with confidence by Alan Smith - Power of Business Intelligence
The Financial Times is a source of great data-driven stories told through data visualization. The Financial Times vocabulary poster is a simple yet comprehensive tool … Read More
Power BI: Hacking a bar chart into table – Random Procrastination
Power BI Bookmarks - Iteration Insights
This blog walks through how to use Power BI Bookmarks and it's capabilities that allows users to capture a specific state of a report page.
Smart Buttons & Power BI Reporting — DATA GOBLINS
In this post we look at how to use Smart Buttons (flic) with Power Automate and Power BI to create and control types of event-driven reporting solutions.
How to develop an accessible colour palette for Power BI | endjin
If the audience for your Power BI report is larger than 12 people, then statistically 1 of your audience suffers from Colour Vision Deficiency. In this post we will talk through how we experimented with colour to develop an accessible colour palette and why colour and contrast is important when it comes to data visualisation.
Automatically plug or balance your balance sheet in Power BI –
Learn how to automatically balance the balance sheet in Power BI. Bookkeeping doesn't contain PnL bookings yet? Planned figures don't add up?
What to know about the new accessible Power BI themes
In February 2023, Microsoft released some new Power BI themes that are more accessible than the other themes available by default. The blog post mentions the prevalence of color vision deficiency (…
(Livestream Replay) Next Gen Visualizations in Power BI - with Gopal — Havens Consulting
ABSTRACT 📄 Deliver Advanced Visualizations with Data Stories in no-code user experience in just few clicks. How Inforiver Charts is helping Tableau, Qlik and Tibco Spotfire customers to migrate to Power BI by offering change management with coverage to missing features and functionalities.
How to get a CLOCK in your Power BI Report - Guy in a Cube
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/
Bar Chart Styles - Data + Science
Data Visualization, Data Mining and Tableau - ideas for barchart visuals.

Creating and Displaying a Last Refresh Date Measure
usiness users often need to know how fresh the data is that they see on a Power BI report. This requirement can be interpreted to mean either “when was the last date & time that the sour…
Generating Measure descriptions with ChatGPT – part 2 – Random Procrastination
Check & Query Data from Tabular Editor — DATA GOBLINS
In this article we look at four different ways to query data from within Tabular Editor. I also share a C# script to query or test selected columns and/or measures.
Perspective Editor | Tabular Editor Documentation
Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor – Random Procrastination
Understanding blank row and limited relationships
DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This article shows the effect of not having a blank row in your tables. We dedicated a previous article to the blank row in DAX. In that ar
Speed up Distinct Count calculations in Power BI using Aggregations - Phil Seamark on DAX
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations
The Balanced Scorecard—Measures that Drive Performance
What you measure is what you get. Senior executives understand that their organization’s measurement system strongly affects the behavior of managers and employees. Executives also understand that traditional financial accounting measures like return-on-investment and earnings-per-share can give misleading signals for continuous improvement and innovation—activities today’s competitive environment demands. The traditional financial performance measures worked well […]
How to Build an Analytics Strategy Roadmap
This blog explores the 4 steps that can genuinely help your organization build an actionable analytics strategy roadmap. Read today!
What is DataOps?