Blogs

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 ...

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 ...

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 ...

Hi Friend,  When New York was first picked as a stop on the Power Platform World Tour ,  the topic of how the Microsoft Power Platform was being used to influence change in the NY Taxicab system seemed fitting. Although Dynamic Communities has made the decision to take a virtual approach to this event to ensure the health and safety of our community, we still find value in sharing this story about big data and Power BI. Power BI Reporting and Integration with Azure Synapse Analytics Meet Jared Brown  and  Kenneth (KC) Philcox   from  Tallan – two guys who certainly get data and analytics. Their story is something ...

Hi folks! In the last few days we have observed several news about the Coronavirus that started in China and around the world today is globalized in several regions of the world! My concern is to understand the seriousness of this moment and nothing better than numbers to reach the conclusion that the situation is critical! See my dashboard, I would be grateful for your comment or suggestion for improvement! Link to report: https://app.powerbi.com/view?r=eyJrIjoiNDRhNjQwNjQtZjRlNC00NDEzLTljMGEtMGUxNDRhZTJiNzY2IiwidCI6ImRkYzM1ZDUzLTgxMzUtNDYyNy1hYzM3LWIwZjAwNjQwNGI3MSJ9 Thanks! Vithor da Silva e Silva | Power BI UG Leader - Vitória-ES ...

Hi everyone. This is my first post (in Elnglish), and I hope you can help me. I have a table of dates with all the necessary fields ([Year], [Month], [MonthName], etc) I have another table 'Results' with records of various types (Sales, Returns, Discounts, etc; all these in a single field [Description]) and the value of each record per month [Amount]. I must say that this table is of monthly closing results, so two things happen: (1) to July I will have records until June of that year and (2) for each description there is only one record per month. Both tables are related by the [Dates] field. I want to do a sales analysis comparing one year ...

Hola a todos. Este es mi primer post, espero que puedan ayudarme. Tengo una tabla de fechas con todos los campos necesarios ([Año], [Mes], [NombreMes], etc) Tengo otra tabla 'Resultados' con registros de varios tipos (Ventas, Devoluciones, Descuentos, etc; todos estos en un solo campo [Descripción]) y el valor de cada registro por mes [Monto]. He de decir que esta tabla es de resultados de cierre mensual, así que ocurren dos cosas: (1) a julio tendré registros hasta junio de ese año y (2) por cada descripción hay un sólo registro por mes.  Ambas tablas están relacionadas por el campo [Fechas]. Quiero hacer un análisis de ventas comparando ...