This article describes different techniques to debug a DAX measure that returns an incorrect result, with and without external tools. Finding errors in DAX
Aggregation Options in Power BI and SQL Server Analysis Services - Olivier Travers
Pre-computing aggregates from granular data to improve live performance for end users by using computing resources at scheduled times is a well-established software pattern. In this entry we'll look at how to set up aggregations across Microsoft business intelligence products. This functionality breaks the pattern of how most features have flown through the genealogy of
Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
Now you can embed entire Power BI organizational apps in Microsoft Teams tabs. By adding Org apps in channels and meetings, you enable everyone to access the data they need.
Announcing backup and restore improvements for large datasets near the size limit
Thanks to the latest backup and restore improvements, you can now restore a backup file even when the dataset size is near the Power BI Premium SKU limitation. You no longer need to be concerned that dataset size limits impact restorability. When restoring a dataset with the /forceRestore option, Power BI will try its best to perform the restore operation even when the available memory is limited.
Announcing: Viva Goals + Metrics integration, scorecard time zones and more
New year, new features! We are excited to announce the general availability of the Viva Goals Power BI integration and three new Metrics features specifically answering common customer asks. A new, optional column for milestones, scorecard time zones, and a handy auto collapse / auto expand feature.
Unpivot a matrix with multiple fields on columns in Power Query
I had to do this for a client the other day, and I realized I hadn’t blogged about it. Let’s say you need to include data in a Power BI model, but the only source of the data is a matri…
Announcing My workspace governance improvement (Public Preview)
Announcing Public Preview of new My workspace governance features that address some of the pain points of governing My workspaces for Power BI Service Admins
Announcing Connected Excel Tables from Power BI (Public Preview)
This feature allows users to export an Excel table from a Power BI report and keep that table connected to Power BI by refreshing it in the Excel grid.
The “Tyranny of the Deliverable”, and other short stories about why you’re struggling to realize big value with Power Platform — Andrew D Welch
Too many organizations are still struggling to go big with Power Platform not because of limitations in technology, but because of their own outmoded ways of doing business, though I know of no other move that IT decision makers in organizations across the economy and around the world can make that
Proper use of table distributions in Synapse Dedicated SQL Pools is easily the #1 shortcoming in Synapse implementations.I regularly see large queries that t...
(5) 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
Hope you’re all enjoying the fall! With the changing of the leaves comes a changed on-premises data gateway. Download the October version to use the same query execution logic/run-time as in the October version of Power BI Desktop.
Announcing the Public Preview of Power BI Dataset Scale-Out
Today, we are excited to announce the public preview of Power BI Dataset Scale-Out, a dataset feature enabling enterprise customers to support large-scale Power BI solutions without any additional administrative overhead or infrastructure complexity.
Chris Webb's BI Blog: Speed Up Power BI Dataset Refresh Performance In Premium Or PPU By Changing The “Parallel Loading Of Tables” Setting
Do you have a a large dataset in Power BI Premium or Premium Per User? Do you have more than six tables that take a significant amount of time to refresh? If so, you may be able to speed up the per…
Elephant In The Room: Data Storytelling Is More Than Just Data Visualization
For many people, data storytelling is just an extension of data visualization. Most of the focus is spent on the explanatory data visualization techniques that are employed in data stories. By focusing primarily on the visuals, the two other key elements of data stories--data and narrative--are often misunderstood and overlooked. It's time for organizations to embrace a more balanced approach to data storytelling that is centered around the effective communication of insights, not just the data visualization aspects.
Deneb-Vega data visualization examples - Power of Business Intelligence
This page presents examples of Vega data visualizations created by Andrzej Leszkiewicz Vega is a declarative language for creating highly customizable interactive visualization designs. Vega … Read More
IBCS with Power BI’s Built-In Visuals & Custom Visuals
Important disclaimer for this article: my whole blog and this blog post is unaffiliated with Microsoft; any opinions or comments expressed in here are my own. Power BI is a powerful tool for creati…
Monitoring Synapse serverless SQL pool query history
This article will walk you through the different ways of how to monitor serverless SQL requests. By reviewing this article, you will understand what to see, compare and how to troubleshoot the query execution behavior. At the end of this article, I will also share how to create a solution to retain ...
(Livestream Replay) ChatGPT...Fad or Future? - Practical use-cases for Power BI - with Mathias Halkjær — Havens Consulting
ABSTRACT 📄 As chatbots become more prevalent in the business world, many companies are wondering if ChatGPT is just a passing fad or if it has real staying power. A new tool that has the potential to help us streamline our workflows by providing automated assistance with tasks such as data model