Power BI

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[…]

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 …

Here’s a twist on dynamically filtering visuals by a slicer in Power BI! You can’t use a measure directly in a slicer, so here’s a way to get a similar experience and maintain usability of your reports. Scott Sewell: https://twitter.com/scottsewell BI Elite Video: https://www.youtube.com/watch?v=AZAL-QPn5Zc

Join the Power BI team and be inspired by community experts, learn best practices, and discover helpful resources with other attendees.

Title of the document

Microsoft has partnered with Wolfram to provide new data types, and we are excited to announce their availability for all Microsoft 365 Family and Personal subscribers in English! Getting reliable data from trusted online data sources into your Excel workbook on subjects like cities, foods, animals,...

Learn about Step Folding Indicators and Query Plan features for Power Query Online!

A video on how to make Power BI refreshes faster

Sum the visible values of a table in Power BI

Following on from my last post, another SQLBits session of mine I wanted to highlight was “Advanced Analytics Features In Power BI”. The subject is a bit outside my normal area of exper…

Being a Power BI enthusiast, I always find DAX a challenge but have found success by keeping to a couple of simple tricks. In this Power BI Tutorial, we review my DAX development workflow through an example case where we will use Power BI Desktop to create a KPI measure

How to display the distribution of the distance between transactions in a column chart? Let’s see how to implement a complex calculation splitting a c

Going forward, there will be two major changes to the Power BI Deployment & Governance training course. Video content will be consumed by participants on-demand Group Q&A sessions, will be held independently, will be live at multiple times to accommodate global time zones