Power BI

This article describes how to implement currency conversion for reporting purposes in Power BI. Currency conversion applied to reporting can include many di

One of the interesting calculation challenges in BI systems is a segmentation or grouping on a numeric value, based on an occurrence of another value. As an example; You might want to know How many customers ordered once, twice, three times or more. The challenge is that the data in the transactional table is not…

In the previous part of this article, I explained what is the segmentation challenge, when you want to group data based on the aggregated result, and I explained a static method of creating aggregated tables and creating a relationship to the main detailed table. However, the caveat of that method is the segmentation is done…

Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a flatten table.…

The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can…

We’re excited to announce the new Power BI tab for Microsoft Teams with support for reports in the new workspace experiences, Power BI apps, and paginated reports. Add the tab to your channels and chats so it’s easy to find and track the data you and your teams need to achieve your objectives. your job done.

Today, I’m excited to announce that we’re introducing Featured content on Power BI Home. Now, administrators or designated promoters will have a dedicated section on Home to promote reports, dashboards, and apps and set the default recommended content for their end users.

In the past two months we added 18 new connectors, bringing the total number of connectors to 315! This includes one of the mostly highly-requested connectors: SAP ERP. Also read about updates to the Power Automate Governance and Deployment Whitepaper and the Power Platform Center of Excellence Starter Kit.

In case you missed our announcement at Ignite 2019, we launched the preview of UI flows, the new robotic process automation (RPA) capability in Microsoft Power Automate. Today, we’re announcing that UI flows will be generally available worldwide April 2!

Back in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the p…

A quick point: while the Power Query Query Diagnostics functionality is relatively new, it’s based on Power BI/Power Query trace logging that has been around for a while. I’ve just real…

Want to use a custom font within Power BI Desktop, but don’t see a way to do it? Here’s a trick to use that custom font. Download Sample Theme

<p>Today, the Power Apps team is excited to announce the public preview for two core canvas apps UI extensibility areas – Canvas components and Power Apps component framework. Both these features contribute directly towards Power Apps mission – Empower every developer to do more.</p>

Use Datset owner’s UPN for Refresh-based Reports

We’re excited to announce the release of Power BI APIs .NET SDK v3. The new version is easier to use, have additional capabilities including the new credentials classes and easier way to encrypt credentials.

Learn how to determine if your revenue growth is good by checking if your margins expanded using Power BI measure branching.

Data Analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI.

Calculate net working days like in Excel with my new Date.Networkdays function for Power Query. For holidays, simply refefrence column of a calendar table

Test your JavaScript, CSS, HTML or CoffeeScript online with JSFiddle code editor.

Make sure you’re making intentional visual choices

A brief look at the foundational elements of Power Automate. We’re excited about several exciting features that will become generally available this year and wanted to take a moment to recap the journey that brought us here so that you get a brief look at some of the most important features which are now part of Power Automate, ensuring it is the most comprehensive and advanced automation service for your organization.

We are pleased to announce that, in addition to incremental refresh reaching general availability, it is also now available with Power BI Pro licensing.

Reading Time: 3 minutes I don’t usually comment on the Gartner Magic Quadrant for Analytics & BI other than to congratulate vendor teams on their work, but I would like to encourage people to at least skim the report. Reprints are available free from many of the vendors. Why bring this up? I’ve seen a few misleading comments about…

<p>The Power Apps April release wave has some exciting end user productivity enhancements that you can try out and start to take advantage of now for your Model-driven apps.</p>

And here's a link to "The Human Impact of Data Literacy" report that's mentioned in the above article: https://t.co/xeFCOiNM1t— Melissa Coates (@SQLChick) February 19, 2020

We are super excited for our update this month! We are releasing two of our top community requests: incremental refresh for Pro and hierarchical slicer. Additionally, we’ve added some improvements to the new ribbon and a couple new DAX functions. Since our last release, there have been several new custom visuals released on AppSource, so be sure to try them out! If you want to learn about all the updates and enhancements this month, check out the full blog.

Announcing General Availability (GA) of Bring Your Own encryption Keys (BYOK) for Power BI