In the coming days you have a meeting with technical people about PowerShell and would like to start with a survey to get an idea of the knowledge about PowerShell of the people in the room. Putting hands in the air is old school … No?
In the new workspaces, the Power BI Service offers a set of 4 roles where 3 of them (Admin, Member, and Contributor) have rights for deleting a dataset and everything that is connected to it. A catastrophe can occur with just 3 clicks. Today, I would like to show you how to protect a dataset from an unwanted deletion.
The purpose of this article is to explain how to generate an Organization Chart in an industrialized and fast manner, without error and with the minimum of manual interventions, in order to be able to display it in Power BI.
If you prefer a video rather than an article, go to the bottom of this post.
This organization chart should allow you to visualize complex organizations, with large quantities of entities (up to several hundreds), several levels of ownership (ex: level 1: holding company, level 2: company A and company B, level 3: company A1, A2, and B1 and B2), as well as multi-parent relationships (e.g. Company X is owned by both Company A at 49% and Company B at 51%.)
In order to make this possible, we describe, in detail, all the steps that are necessary. We unsuccessfully tried many custom visuals (see image below), and the use of Microsoft Visio, through the use of the Organization Chart Wizard, is the optimal solution that we had envisioned.
EARLIER () may be one of the more confusing functions to understand. Many of us deal with it by using an index to track on which row we are located and to which we can refer when writing our DAX formulas. Or we use a date column because of its sequential order. What if we have a date column that has duplicate dates that lead the engine to return an error? What if there is a way to have an Index column to be more than just a signpost? This is what I discovered when answering a question on this forum.
The app Power BI Desktop contains lots of data connectors. You can connect to many database systems, read a file or you can even parse a table from a web site. But sometimes you need to create a table by yourself. We even have a button in Power BI for that: Enter Data. Do you know what happens when you create a table this way?
We’re excited about all the new innovations we’re rolling out in the October 2019 Microsoft business applications release and want to share the highlights with you. Please join us for the Microsoft Business Applications Virtual Launch Event on October 10, 2019 from 8:00 AM – 9:30 AM Pacific Time.
In the last few months I have been answering dozens of users’ questions. And there were at least three or four of you with different use cases but the same nominator: I have a table with two columns From and To. And for every distinct value of the column From I want to see all nodes which I can reach by traversing the edges From --> To. This problem has a name: transitive closure.
This article explains how to create a Date Dimension Table in Power BI’s Query Editor with an additional set of columns that will allow you to sort report display columns in your Date Dimension, add conditional formatting capabilities, and last but not least, perform relative filtering on current ( 0 ), previous ( -1, -2… ) or future ( 1, 2... ) Date, Week or Month and many more.
My business has had a massive data overhaul in the last 18 months, with all of it being supported by Power BI with SQL server backend. I wanted to detail here my experience with going from literally nothing, to full use of Power BI, what problems we encountered, and how PBI and the Community helped us to overcome them.
Power BI has completly changed the way in which the business views and accesses data. Power BI has truly changed our workplace for the better.
I have prepared an article about a transitive closure in Power Query (coming in 2 weeks). I wanted to publish the article already, but I decided to wait a little bit and write another one about a performance boost I’ve used in the code. It is a lookup table in Power Query.
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. Currently, there is no direct way of Implementing CICD in PowerBI. Using the Publish menu from the PowerBI Desktop is the easiest way to deploy/publish a report as of now. In this article, we are going to see how we can implement source control and CICD for PowerBI using Azure DevOps.
Power BI has introduced a new workspace experience.The new workspace is now the default workspace after General availability(April 2019). The new workspace and the classic workspace coexist side by side, and you can create either, but the new workspace experience is the default workspace type. Workspace is the method of collaborating with colleagues for creating collection of reports and dashboards.
Our customers often ask us in our projects or workshops why Power BI is so successful in the area of Business Intelligence. Besides all the advantages like Self-Service BI (especially for non-technical persons), connectivity to a lot of data sources, creation of stunning reports and dashboards, great possibilities for sharing and collaboration etc. there is one big reason for it: DAX!
Usage metrics is one of the feature in Power BI Service. The usage metrics report will give you an analysis of how many times the content is viewed or share, through which platforms (web or mobile), and by which users.
Azure Analysis Services (AAS) doesn’t have a native Azure Data Lake Gen 2 (ADLSg2) connector yet, but now there’s a preview of “ADLSg2 Multi-Protocol Access” which allows using Blob’s API to access files in ADLSg2. This post describes a short step-by-step on connecting AAS to ADLSg2 using Blob API.
If you have spent any time in the Power BI Community, you have probably noticed regular contributors through community blog posts, activity in the Power BI forum discussions, and authored accepted solutions. Super Users are outstanding participants and expert users who regularly contribute useful solutions. Their advice is invaluable and it shows because they are in the Top Kudoed Authors Leaderboard in the Microsoft Power BI Community. See some familiar names? Their Community contributions and Power BI expertise continues to make the Power BI Community a valuable place.
Last month, Power BI partnered with Hacking STEM and NASA to create an interactive, educational data story to teach students about radiation. Educators loved the idea of bringing Power BI data stories to the classroom, and they are looking for more! So this month, we are launching a "Back to School" Contest to empower and engage students with Power BI! The contest will run from August 1st to September 6th, and the winners will be featured in the Power BI Blog! Channel your love for education and get started today!
What I wanted to do in this example is to show you how you can manage multiple dates in your Power BI tables. It's very common when I see Power BI users first seeing or coming across this particular scenario with their developer. There's always a bit of confusion on how you actually set up the data model correctly so that you can generate these insights that you need to work across multiple dates and this mainly lies within the data model.