cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Administrator Syndicate_Admin
Administrator

 

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?

 

Read more...

Super User
Super User

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.

Read more...

augustindelaf Member
Member

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

 

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.

Read more...

jfeil Member
Member

The Microsoft business applications virtual launch event is almost here! You don’t want to miss this opportunity to get a first-hand look at the new innovations we’re rolling out for Power BI.

Read more...

Super User
Super User

Did you know that the sort order of Table.Sort will not be kept reliably? 

Learn how to fix that here:

Read more...

Nathaniel_C Super Contributor
Super Contributor

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.

Read more...

Super User
Super User

Do you remember my previous article about Solving Real Life Problems with Recursive Functions in Power Query? It is about splitting all datetime columns into 2 columns: date and time. It comes in hand if you want to achieve a high compression rate in your dataset, because the less unique values you have in a column the better it can be compressed. In the further article (Date Dimension with Holidays in Power Query) I explained how to create a date dimension in Power Query. What we are still missing is a time dimension.

Read more...

Administrator sivah
Administrator

The Power BI engineering team develops and maintains several workshops and classes that are  available to our partners and community leads for free to help them to train their customers and communities

on Power BI. 

Read more...

Super User
Super User

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?

Read more...

jfeil Member
Member

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.

Read more...

Super User
Super User

It was about a week ago when I published a blog post about transitive closure in Power Query: https://community.powerbi.com/t5/Community-Blog/Transitive-Closure-in-Power-Query/bc-p/786063. As you can see, under the original blog post there are some great comments about possible performance boosts and functionality improvements. I’d like to present you the improved solution.

Read more...

nandukrishnavs Frequent Visitor
Frequent Visitor

In this article, I'm going to explain how to implement dynamic RLS in Power BI.

Read more...

Super User
Super User

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.

Read more...

jfeil Member
Member

Remember the recent blogs about the folks at the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) who are using Power BI to help prevent and eliminate Pediatric AIDS? And the folks at the Center for Oceans at Conservation International (CI) who are using Power BI to improve ocean health? Well one reader was so inspired by those amazing people and their stories, that he set out to find a way he could use Power BI to make a difference.

Read more...

Super User
Super User

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.

Read more...

jfeil Member
Member

If you were an MBAS Speaker, make sure to claim your badge!

Read more...

MCornish Member
Member

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.

Read more...

Super User
Super User

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.

Read more...

Jayendran Established Member
Established Member

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.

Read more...

Amit_PowerBIPro Member
Member

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.

Read more...

torsten Visitor
Visitor

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!

Read more...

Amit_PowerBIPro Member
Member

What is usage metrics?

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.

Read more...

Power BI Team drubiolo
Power BI Team

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.

Read more...

Super User
Super User

You know that, too. A user calls you and asks when a dataset has been updated for the last time. What do you answer?

I also had this problem but that is over now. And it will become only a memory for you, as well, if you read this article and implement the last timestamp of loading data into your dataset.

Read more...

jfeil Member
Member

Do you belong to a local Power Platform User Group?  Want to let the world know?  Find out how to claim your Community User Group Member badge!

Read more...

ibarrau Senior Member
Senior Member

This post will help you to run custom power query code in Power Bi Desktop from a text file hosted on github so you can manage a repository of functions in your organization.

Read more...

jfeil Member
Member

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.

Read more...

SujataNarayana Frequent Visitor
Frequent Visitor

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!

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

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.

 

Multiple Dates In Power BI.png

 

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.