Power BI

Turn your Power Apps app into a native mobile app with our new wrap for Power Apps step-by-step wizard.

We are excited to announce direct access to Dataverse actions in Power Fx formulas as an Experimental release. As a part of the Power Fx language, authors can now directly invoke a Dataverse action within a formula. A new Power Fx ‘Environment’ language object that authors can add to their app enables access to Dataverse…

We can make a Power Apps button with an icon. The trick is to change the icon & button color using an invisible overlay's pressed property

This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships. A common requirement in report

Power BI is a powerful business intelligence tool that helps organizations to gain insights into their data. With its ability to create stunning visualizations, it’s no wonder that it’s become a popular tool among businesses. [...]

In this article, we look at the difference between best practices and optimizations. We also define a four-step method to tackle complex issues with dataset/report performance and design.

The Power BI app for Microsoft Teams, Outlook, and Office is getting updated multi-tasking experiences to help users complete their tasks faster. Read the blog for all the details.

In Feb 2023 Power BI Update they introduced image width in a table formatting. SVG images can now be rectangle images like this Stars SVG.

In this blog post I describe the new DAX function, LINESTX in Power BI and test it in a brief example. With the February Power BI update, two new DAX statistics functions have been introduced: LINEST and LINESTX. The functions use the Least Squares method to calculate a straight line that best fits the data, then return a table describing the line. The data result from expressions evaluated for each row in a table.

In Feb 2023 Power BI Update they introduced image width in a table formatting. SVG images can now be rectangle images like this Stars SVG.

At some of my most recent customers I've developed an efficient way to analyse & deliver more meaningful, actionable and business-impactful insight to the users. I'd like to share this with you! This is based on Power BI, so I'll talk about DAX and Power BI report design, but it could be adapted to any tool. Using the Adventure Works sample database I created a couple of examples. It reads like a DevOps User Story, which is good as it switches to being busines-driven over data-driven. Some of ou

In this blog post I will share with you how to effectively leverage the performance boosting functionalities available in dataflows when preparing large volumes of data. I have found there are two key components that are critical for developing efficient dataflows: Enhanced Compute Engine – loads data into a temporary SQL cache and enables Power Query to leverage query folding. Incremental refresh – partitions your data into smaller chunks to refresh only what you need. Focusing on these two com

Power BI desktop released a new version in February of 2023, this feature breaks any custom properties observed when uploading a theme file into Power BI desktop. This video show you how to use the PowerBI.tips theme generator to generate files without any errors. Use the Theme generator https://themes.powerbi.tips

Power BI desktop released a new version in February of 2023, this feature breaks any custom properties observed when uploading a theme file into Power BI desktop. This video show you how to use the PowerBI.tips theme generator to generate files without any errors. Use the Theme generator https://themes.powerbi.tips

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!

I believe that — as for any other technologies — algorithms and artificial intelligence will amplify human abilities more than they will…

Introducing the new and simplified Power Apps portal left navigation pane. Do you find it daunting to navigate through the menu items on the pane today? Do you wish you had a quick and easy way to pin items that are most used by you or get a quick glance of all the product features…

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

Create a what-if parameter in Power BI based on end user inputted values

Beware of Power BI migration tools that do things that are unsupported or over-promise

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/

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.

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.

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 (…

Discussions with clients regarding the performance of their data models in Power BI have been a frequent occurrence for me recently. The issues often involve failed refreshes, queries that run slow…

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.