Power BI

In this part, we will start debunking the myth that the Power BI is the "visualization tool only". We will get our hands dirty and start profiling and shaping the data using Power Query Editor!

Power Bi ya tiene un buen tiempo en el mercado. Lo cual implica que en más de una oportunidad los analistas necesitamos partir desde un modelo previamente construido y no comenzar de 0 en un proyecto...

Cierto es que construir un modelo de datos detalladamente para llegar a la estrella deseada hace de nuestro modelo la mejor práctica para su mejor funcionamiento. A pesar de ello podemos caer en la...

Algo que había esquivado por mucho tiempo es la posibilidad de escribir scripts contra Power Bi. Tal vez porque pensaba que NO ameritaba tanto para los medianos modelos con los que trabajo diariamente...

Visualize your data model's relationships in a simple and elegant manner.

A new method to create an automated data dictionary which also works for Power BI Premium models.

Import Vertipaq Analyzer data from a .vpax file into Tabular Editor.

A simple way to process table(s), partition(s) or the model in Tabular Editor.

Learn the best method for adding descriptions to objects in your model.

Learn how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet

Learn how to perform the Merge in Power BI and Power Query based on the BETWEEN operation. The sample showed using customized age bands.

Even for simple Power BI deployments, you need a strong team. These are the roles you need to fill, along with the skills and responsibilities required for each.

It occurred to me that we have put so much effort into promoting best practices and proper design that there is far less information about how to create bad reports and data models. In that light, …

We are excited to announce that connected PivotTable refresh in Excel for the web is now 100% available to all Office tenants. This feature is part of a broader investment to enable seamless and secure data sharing and collaboration with Power BI data in Excel for the web. If you missed the initial availability announcement, connected PivotTable refresh in Excel for the web allows users to work with PivotTables connected to Power BI in a web browser just like in Excel desktop. With the Microsoft Information Protection (MIP) label integration, you can control sharing while keeping your data secure in Excel as an MIP label applied to a Power BI dataset is inherited in Excel. Check out the initial availability announcement of connected PivotTable refresh in Excel for the web for more details on how to work with this feature.

This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default val

Remix Icon is a set of open source neutral style system symbols elaborately crafted for designers and developers. All of the icons are free to use for both personal and commercial.

This question comes up every few years in SQL Server Reporting Services. Of course, in Power BI Paginated Reports, we have the same features. A couple of days ago, Karthik posted this question as a…

Use Power Automate and Office Scripts to generate Excel reports connected to Power BI datasets

When I talk to people who are not deep into the Power BI world, I often get the impression that they think of Power BI as a visualization tool exclusively. In this series of articles, I'll show you how Power BI can be used to create a fully-fledged analytic solution. In the 1st part, we are setting the stage by defining all the phases for building a successful analytic solution!

How many times have you struggled to find the happy medium between a report that looks phenomenal when printed, but has everything a user might need in an Excel export? Stop compromising and start creating Paginated Reports with separate PDF and Excel exports.

Convert a “Top N and others” measure pattern into a calculation group that can be applied to any DAX measure in a Power BI model.

Organizations must continually mature their Power Platform enterprise management in order to unlock the platform’s value as a first-class cloud application platform and scale it over time. The Enterprise Management Maturity Model is the common standard that can be applied across the platform (and

TREATAS: Treats the columns of the input table as columns from other tables. https://dax.guide/treatas/

Getting-started tutorial for the Stream Analytics IoT solution of a tollbooth scenario

The Power BI team has invested a lot over the past year in making datasets better discoverable in the Power BI Service. This helps on many aspects to drive a data culture within your organization, …

We are thrilled to announce that the public preview of streaming dataflows in Power BI is now available for everyone to try out.

Solution based on either Powershell or Power Automate (Flow) to consume the recently released Power BI Asynchronous Unified Scanning API - ferrybouwman/Power-BI-Read-Only-REST-API

Looker was always a bit of mystery for me, as there was no trial version to test, and they have high profile customers, luckily Google recently start providing trial version without asking too much…