Blogs

¿Les ha pasado que dentro de una misma sección en un cuadro de mando de Power BI, algunos usuarios prefieren gráficas de barras y otros prefieren una tabla sencilla y y quedamos analizando como cubrir esa solicitud? ¿O que algunos usuarios solicitan ver indicadores de satisfacción del cliente, pero otros prefieren indicadores de desempeño de sus equipos? Si bien es cierto, podemos organizar cuadros de mandos que muestren la información en secciones y así darle la oportunidad a los usuarios que consulten el área de su preferencia, también podemos combinar todo dentro de una misma sección sin que se vea tan cargada. Al final, tener cuadros ...

While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don’t want these users to refresh the data. Coming with version 1.1.0, Power BI Sidetools exports your data into Excel with only one click. Then you can setup pivot tables, add theme & graphics, macros and do whatever you want. You can even generate a paginated report. Next time you will open this file from Power BI Sidetools, it will be refreshed and you will keep all the setup you did previously. Super quick and super efficient in few steps. You may have a look at this blog post about Power BI Sidetools ...

T he Process Analytics Factory  (PAF)   announced that its latest partnership with Microsoft incorporates   PAFnow Process Mining   software with Microsoft‘s   Power Automate , a new desktop-based Robotic Process Automation (RPA) solution. PAFnow is the only Process Mining tool that is fully integrated with Microsoft Power BI and is a certified software application on Microsoft Azure Marketplace, the   most popular supplier   of public cloud services. The PAF also announced that it will introduce a PAFnow PREMIUM app for RPA/Automation in October. When paired with RPA projects, PAFnow Process Mining can create efficiencies that help ...

Debido al incremento exponencial de los usuarios y clientes que consumen reportes y análisis desarrollado en Power BI, así como el incremento del número de dichos proyectos en Power BI, me he visto en la necesidad de desarrollar una solución (escalable) que tenga por objetivo dos cosas fundamentales: Facilitar a mis clientes el aporte de su opinión sobre los reportes y análisis en Power BI Automatizar y optimizar el análisis y respuesta a dichas opiniones Dado que existen múltiples opciones para implementar la solución a esta misma problemática, he optado por aquella que me ha permitido el mayor grado de escalabilidad, tiempo de ...

Goals of this Post Use Calculation Groups Use Tabular Editor Advanced Scripting Speed up SSAS/PowerBI model development Create reusable script Setting up the Environment Power BI: Download here . Tabular Editor: Download here . SQL Server 2019 or Azure Analysis Services or power bi with external tool. (July 20 or later) Calculation Groups I'm not going to repeat all the technical details that Microsoft has already nicely written  here . The goal of this post is to show another approach on how to use the calculation groups and demonstrate why you may prefer to use this alternative approach ...

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. Transfer DAX and M formulas to files With just one click, you can transfer M and DAX formulas in a folder named like your report. The very first use case will be probably to save your different versions in backups. Right click on your report name and select "Send to/Compressed folder". View your DAX and M formulas in Visual Studio Code With just one click, you open Visual Studio code to view your DAX and M formulas. Visual Studio Code is a lightweight but very powerful free source code editor ...

If you are just getting started with Power BI you may be seeing a lot of references to a 'Calendar' Table or 'Date Table.  Maybe you already have a handle on this aspect of PBI, but a lot of people seem not to understand how to get started.  If you forego having a 'Calendar' Table altogether, you can end up having a very cumbersome file and you won't be able to take advantage of many of the awesome date/time functions offered through Power BI.  There are quite a few good resources already out there.  This post points you to a few of those and helps you get started in both M and DAX. To turn off Time intelligence - here is a great blog resource:  ...

Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. There are news stories published almost daily about data breaches and identity theft. To address this community need, Dynamic Communities has partnered with industry experts in the cyber security world to provide valuable information on how to protect your organization from cyber crime attacks. Join us for a tapas-style (small bits of learning on various topics), no-charge webinar series June 8-10, ...

What's your type? For a beginner in Power BI and in business intelligence in general, it is not easy to understand data types and differentiate them from data format. And then comes data category... So, what's all that about, really? It's true that in spreadsheet applications like Excel, data type is not really of a bother to the user, as there is no functionality to define the type of the data present in cells. We just enter values and it's all fine (somehow). In fact, I only started to bother about data types when starting to use Power Query, Power BI and Power Pivot (data modelling tool in Excel). Power Query is less friendly with typeless ...