Power BI

This month we have a lot of exciting announcements. Two of our most requested features on UserVoice are releasing this month, heat maps and single select slicers. Additionally, we are making our complete facelift of the modeling view generally available. New DAX functions and improvements to existing features, such as buttons and the selection pane, round out this update.

Although very simple, still I get this question very often; How can I show the total value as a data label in a stacked column chart? In this quick blog post, I'm going to show you a quick and easy method to use a combo chart and show the total as a label on top…

Hello P3 Nation! After having the privilege of working with so many of you to share your journeys and techniques I was inspired to share my own. This is a bit of an intimidating group, and I struggled a bit with what to share. After much deliberation, I compromised with myself on a journey story. My journey does not

Begin to understand how to use PowerApps with this introduction and tour of the PowerApps interface from Dries Verdonckt

How to fix and understand the Formula.Firewall error and the Data Privacy Levels inside of Power Query and Power BI Desktop.

This Power BI blog post details how to easily edit long measures that are created in Power BI desktop and how to use the Data View

Approvals in Flows empower you to automate requesting and tracking approvals. With custom response options, you can now create approvals with responses tailored specifically to your business needs. Use custom responses to provide granular feedback for content reviews (E.g.: Approve, Approve with edits, Reject), respond to an approval to offer discount with discount limits (Up … Continue reading “Introducing Custom Response Options for Approvals”

Long-awaited PowerApps Components [PAC] appeared on the end of January 2019 to everyone’s delight. From then on PowerApps developers can create their own controls that can be reused on a screen or across multiple screens and at the same time being central-manageable and migrate-able due to import/export option. PowerApps components can has it’s own custom … Continue reading "PowerApps components patterns"

This article describes how the Join types in Power Query work in a visually animated way that makes it easier for beginners to understand.

Now that Azure Data Lake Storage Gen2 is now based on Azure Storage as its foundation, we have a new level to incorporate into our planning process the file system itself. The file system contains the files and folders, and is equivalent to a container in Azure Blob Storage which contains blobs. In

In the last two parts, first how we able to use cognitive service in Power BI service (Data flow) has been explained. Then in the second one, the process of using a Pre-built machine learning model for prediction ( classification, regression, and forecasting) has been explained. In this post, I am going to show how…

For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user's world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to…

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup129 2 Minute Tuesday: https://guyinacu.be/geekshirts Patrick’s tech video: https://guyinacu.be/webfromexample Adam’s tech video: https://guyinacu.be/adminportal Sources Calculation Groups in DAX – first impressions (@marcorus) EXPLORING POWER BI’S KEY INFLUENCERS (@Jcrit44) Power BI Premium Deployment and Management Whitepaper added! Tailoring help and support for Power BI […]

Adam looks at the Power BI Admin Portal and the roles you need to be able to access and manage your Power BI items. This consists of two potential roles within Azure Active Directory or Office 365.

Register for this webinar to learn how Microsoft Power BI helps you manage financial planning and analysis more easily and effectively.

The weekly Power BI Roundup details the latest updates in the Power BI world with this week around dataflows, MBAS 2019, On-Premise Data Gateway

Today, we’re excited to announce that Power BI is making it easier for Azure AD B2B Guest users to collaborate with colleagues across organizational boundaries. Rolling out to production this week is a new capability that allows external Guest users to edit and manage content in workspaces, get the full home experience, and to do … Continue reading “Azure AD B2B Guest users can now edit and manage content in Power BI to collaborate better across organizations”

We are happy to announce the General Availability (GA) of Multi Geo for Power BI Premium! With Multi Geo going GA, you can extend your Power BI tenant to store your users’ data in the geographies covered in the Microsoft Trust Center, except for Power BI Germany, Power BI China operated by 21Vianet or Power … Continue reading “Announcing Power BI Multi Geo General Availability”

The month of February 2019 witnessed the release of Power BI Desktop unveiled a new, out-of-the-box visual to Power BI called Key Influencers.

The newest version of the Power BI Desktop and Power Query for Excel, you can combine multiple data from Excel files into one big tall table.

In modern BI projects, understanding the flow of data from the data source to its destination is a key challenge for many customers.

With sophisticated models and scalable compute, Artificial Intelligence becomes a realistic tool for data analysts. Power BI helps you get insights from your data. Now, with access to a set of models from Azure Cognitive Services and your custom models in Azure ML, you can easily enrich those insights with AI. Cognitive services in Power BI gives you access … Continue reading “Easy access to AI in Power BI (Preview)”

Wil Reynolds asked an awesome question about how to use multiple URLs with the web from example Power BI feature. The magic is with Power Query functions and parameters. Patrick has you covered!

Bulk-extract Power Query M-code from multiple Excel files at once: Made easy with just one M-function that is easy to apply.

In the last post, the process of using Cognitive services Text analytics has been presented. In this post, I will show how to user pre-built AI using some predefined machine learning algorithms in Power BI Service in Data flow. I will follow the same example I show in the Azure ML Studio and Power…