Power BI

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 …

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 …

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

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 … <p class="link-more"><a href="https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-in-jupyter-notebooks/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing Power BI in Jupyter notebooks”</span></a></p>

Don’t miss the upcoming free SQLBI live event on Wednesday May 26, 2021! Past are days of creating data models with a single monolithic tool provided by M

A tool for managing the processing of large tabular models.

View common advanced filtering patterns used in Tabular Editor.

Generate aggregation tables automatically for your model.

Learn how to see a preview of your data in Tabular Editor.

Quickly extract model metadata into a user-friendly output.

A framework that dynamically creates a tabular model based on an Excel template.

Learn how to quantify the savings of following a particular best practice rule.

Previously I explained the AddColumns function as a function that adds one or more columns to the existing table, In this article and video, I’ll explain another similar and useful function with slightly different behavior: SelectColumns, and you will learn how you can use it in Power BI and DAX. SELECTCOLUMNS is a Tabular function Read more about Create a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function[…]

In this lab we will be implementing a forecasting measure using DAX. We will not be generating a forecast data set, rather, we will create a measure that will look at the actuals from the past to f…

We OPTIMIZE PERFORMANCE on a lot of models for Power BI. And, over the years, we start with the same first few things. Adam walks you through his steps. Performance Analyzer: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer DAX Studio: https://daxstudio.org/ Tabular Editor: https://tabulareditor.com/ Best Practice Rules: https://powerbi.microsoft.com/blog/best-practice-rules-to-improve-your-models-performance-and-design-v1-1/ Guidance Docs: https://docs.microsoft.com/power-bi/guidance/ One Checkbox video: https://www.youtube.com/watch?v=RnDdDlozcdo

See the latest version of the best practice rules to improve your model’s performance and design!

CSG ProCustom Software, Business Intelligence and Cloud Servicespower bi implementationsWhat to Expect When You’re Expecting a Power BI ImplementationThe implementation of a tool is even more …

We are excited to announce a new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files.  We’ve received many requests for this feature after the introduction of PQ query refresh.  Now you can import data from local files including Excel workbooks and text & CSV fi...

Power BI is changing the game for modern enterprise BI by seamlessly integrating with cutting-edge big data, data warehouse, and data virtualization technologies, such as Denodo. The Denodo platform …