Power BI

If you want to show the ranking in a Power BI visual, one way is to use a visual that supports that, such as a Ribbon chart. Another way, which is a more common way, is to write a calculation for rank, and RANKX is a DAX function that can help you with that. In Read more about Showing Ranking in a Visual in Power BI using RANKX DAX function[…]

Microsoft Excel is one of the most common data sources for Power BI. We can store Excel files in various storage types. The way we get data from Excel varies depending on the storage type. In this post, I quickly show two methods to connect to an Excel file stored in SharePoint Online. Method 1: … Continue reading Quick Tips: Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop

Looking for ANOMALIES in Power BI? Justyna Lucznik walks Patrick through the new anomaly detection in Power BI and gives a SNEAK PEAK at what’s coming! Anomaly detection: https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-anomaly-detection

Learn how a Center of Excellence helped Microsoft create a standardized analytics and data platform to unlock insights with the right operating model, stakeholder engagement, and shared and dedicated investments.

Log Analytics is a basic tool for the entire Azure environment, I wrote about it before.The possibility to access log analytics data from a tool for analysis, such as Power BI, only increases its …

Power Apps controls, although powerful, provide limited branding and customization capabilities. With Google investing a lot in research to come up

Dialog Control Dialog controls are modal UI overlays that provide contextual app information. They block interactions with the app window until being explicitly dismissed. They often request some kind of action from the user. Property Description OpenClose   Buttons Table({Label: "Cancel", Fill:...

Power Apps Canvas Modal Dialog (Popup) If you don't feel like rea din g the installation instructions below, you can watch these videos to get up and

Give a Thumbs up if you like this component. This makes it easier for others to find in the gallery.   My Twitter handle is: formsandflows. Send me a DM if you find any bugs and I will try to fix them as quickly as possible.   *** How to use it *** This component has 6 input properties. They ...

Hello everyone, This video is a step-by-step walkthrough of building a responsive PowerApps Navigation Menu Component / Left Navigation component /

GlbApp is a component that can stock the Controls, and allow dynamic styles properties settings. You can copy and past Controls into your new application and boot the component.   GlbApp's updates will automatically update the applications' Controls. (We used the application "Template" in our ex...

Hello #PowerAddicts, Have you ever had a requirement to build Mega Nav in Power Apps? If yes, then you have it - "Power Mega NAV

In this article we demonstrate how to use calculation groups to show the behavior of any measure in the last 6 months, starting from a single date selection

Join the Power BI team and be inspired by presentations, learn best practices, and discover helpful resources with other attendees. Join your DEV community for live discussions on camera, and in chat …

As companies strive to be more nimble and focus productivity on innovation, workplace automation is taking center stage. With the right tools, like Microsoft Power Automate, everyone can reduce time-consuming tasks to focus on what matters most. In fact, the month after Microsoft Ignite, where we announced Power Automate Desktop was available at no additional cost for Windows 10 users, Power Automate increased download rates six times month-over-month, empowering even more customers with automation.

Scenario: In Power BI Desktop, when we connect to a .json file, power query editor will transform it automatically if its structure is single. Sample data1: Output in power query: From the APPLIED STEPS we can find that power query editor expands all columns automatically to get this result table....

We all write our codes in a proper format so that readability and understanding of codes become easy. While working with POWER BI, we use DAX Expressions to write our measures and calculated columns. We know that formatting is not required in DAX. It’s normal to see DAX expressions that span over 10...

What KPIs should your BI team be thinking about? This podcast covers this topic. We discuss how to measure success as a BI team.

Writing a native SQL query in Power BI will break query folding, right? Well, not anymore...

This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your data models. A conditional expression in DAX – like an IF function – can be evaluated in two ways: eager and strict. Understanding the difference be

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

We are excited to announce the preview release of three new Power Apps Solutions on Dataverse for Teams: Profile+, Boards, and Perspectives. These apps are an addition to the series of extendable sample apps such as Employee Ideas, Inspections, Issue Reporting, Bulletins, and Milestones. These template solutions are helping organizations accelerate their journey to integrate Line of Business applications directly into the collaboration fabric of Teams and unlocking the next stage of digital transformation. Learn more about how you can leverage these recently released template solutions to enhance information discovery and creating a more inclusive culture in your organization.

Announcing Power Fx integration with Model-driven Power Apps commanding and Dataverse calculated columns and rollups. We have also partnered with Acumatica to evaluate how Power Fx can be leveraged with the low code/no code experience they offer to their customers. And finally we have an update on our planned open source architecture.

The ultimate low-code app building experience is one where you describe in plain language what you want an app to do, and in an instant that app is created for you.

My favourite Power BI announcement at the Microsoft Business Applications Summit was, without a doubt, that Excel PivotTables connected to Power BI datasets will very soon work in the browser and n…

When you hear someone say that governance and self-service BI don’t go together, or some variation on the tired old “Power BI doesn’t do data governance” trope, you should i…

Learn how to export the results of the Best Practice Analyzer.

Since our launch over five years ago, Microsoft Power BI has been enthusiastically adopted by developers across the spectrum. Today we have over three million active developers on Power BI—who harness the power of data, provide actionable insights, and deliver cloud-native intelligent experiences. Today, over 15,000 independent software vendors (ISVs) and enterprise customers use Power BI’s embedded APIs to build analytic experiences into their applications. At Microsoft Build, we are delighted to celebrate our developers and share some exciting updates for our next generation of developer experiences.

Deployment pipelines can be automated! With the first set of APIs, you can automate deployments or integrate the deployment process into familiar tools, like Azure Pipelines or GitHub Actions.

We’re excited to announce the release of Power BI in Jupyter notebooks. You can now tell compelling data stories with Power BI in Jupyter notebooks. Get your Power BI analytics in a Jupyter notebook with the new powerbiclient Python package. The new package lets you embed Power BI reports, dashboards, dashboard tiles, report visuals or … Continue reading “Announcing Power BI in Jupyter notebooks”