Power BI

Data Visualization, Data Mining and Tableau - ideas for barchart visuals.

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

Data literacy is an in-demand skill for many workers and a stepping stone to becoming a data-driven organization. Here’s how to get started.

As we enter a new year, more gyms are packed, more books are read, but within the first month, about a third of individuals will see a dissolution of their goals. Setting goals and sticking to them isn’t just a challenge for personal pursuits—it holds true for your professional life too.    Organiza...

Learn about the details and properties of the SubwayNav control in the Creator Kit.

If you have launched the preview maker portal in the last week or so, you might have seen some big changes in the navigation and the ability to customize this to fit the needs of the maker. In this post, I will demonstrate some of the new highlights of the new preview portal (currently in Preview), and discuss some of the benefits.

Bayer is a life science company and a global leader in healthcare and nutrition—and the organization’s work became even more critical during the COVID-19 pandemic. To keep its employees safe and business production on track, the Bayer crisis management team needed access to critical COVID information for the ASEAN country group. Using datamart in Power BI, the organization built a dashboard that delivers insights in real time, enabling better decision making and enhancing cross-team collaboration for future crisis management needs.

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 […]

Learn how to automatically balance the balance sheet in Power BI. Bookkeeping doesn't contain PnL bookings yet? Planned figures don't add up?

Power Component Framework can be used to enhance the user experience for users working with data on forms, views, dashboards, and even canvas app screens. Learn more in #LowCodeFebruary.

Contribute to KornAlexander/PBI-Tools development by creating an account on GitHub.

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.

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.

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.

The ultimate snapshot report shows all changes between snapshots and historical records for relevant order Ids using LOOKUPVALUE

Today, we will talk about OpenAI and the Microsoft Power Platform and how to build next-gen application with it. Over the past few weeks, social-media feeds and newsletters have been filled with stories and conversations about artificial intelligence (AI). ChatGPT and OpenAI were often center of the...

Tutorial: Create smart narrative summary visualizations in Power BI

Welcome to the February 2023 update! This month, we’ve added TypeScript support in the developer playground sandbox, several new formatting features for reporting, and so much more. Continue reading for more details on our new features!

Using thr char gpt api and tabular editor you can now add business descriptions to your dax statements.

Last month, we announced Formula by Example starting to roll out to Excel web users. Formula by Example looks for patterns as the user enters data in the worksheet. When it recognizes a pattern, Formula by Example offers a formula to fill the rest of the column with the recognized pattern. The examp...

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.

New Accessible Themes

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

Navigating through snapshots, seeing all changes between them and see all the records for those orderIds is not easy. LOOKUPVALUE can help sove the problem.

The IBCS standard can enhance the clarity of visualizing relative performance by distilling it to its essence, and I enclose a Deneb/Vega-Lite template for such an IBCS-style visual. This is a single composite visual that’s been provided with only category (product), current year (Sales CY), and previous year (Sales PY) data values. This template illustrates a number of Deneb/Vega-Lite features, including: a “title” block with title and subtitle text a “transform” block to extend the datase...

Genie Framework improves Spark Pool utilization by executing multiple Synapse notebooks on the same spark pool instance. Uses vaccum and optimize to maintain efficient delta tables.

Using optimize and vaccum to removed unused delta patition files. Helps maintain a minimized delta table size footprint.