cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

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

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

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

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

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

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

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

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

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

Super User
Super User

We all know how important it is to transform our data into a star schema and to have a fact table and dimension tables. Date dimension is one of those dimensions. We will build one together!

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

I want to dive into two essential DAX functions that you absolutely need to understand well when using Power BI. These functions are CALCULATE and CALCULATETABLE. They are very similar in some aspects but also very different in others. I want to go through these with the accompanying tutorials during this post.

Power BI Community.png

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

I wanted to dive into the topic of supporting tables inside of Power BI in this particular blog. Supporting tables are a unique development technique and are used for supporting logic that you might run through your core data model. Think of your core data model as the look up and fact tables that come from your raw data.


How-To-Use-Supporting-Tables-Within-Your-Data-Model-For-Maximum-Effect-In-Power-BI.png

 

Read more...

Super User
Super User

Are you feeling lost among a lot of columns in Power BI Desktop? Do you prefer order to disorder? Then you are at the right place.

Read more...

Super User
Super User

If you have a dataset in Power BI Desktop and you want to see what happens under the roof of the Vertipaq Engine, there is a great tool known as Vertipaq Analyzer. It can tell you how much space tables and columns consume, what their data types are like, what compress algorithms they use and so on. But before you can start analyzing your dataset, you need to set everything up.

Read more...

sagarnarla Occasional Visitor
Occasional Visitor

Harness the power of Azure Machine Learning in Power BI

Read more...

Amit_PowerBIPro Member
Member

If you are a Power BI Pro user and looking for some support from Microsoft Power BI support team, raise a ticket.

  1. Go to http://support.powerbi.com
    2019-05-03 09_13_55-How to create a support ticket in Power BI - Word.png
  2. Scroll towards the bottom of this Page. Under Still having issues, click CREATE SUPPORT TICKET.
    2019-05-03 09_14_47-How to create a support ticket in Power BI - Word.png

         Note: Pro Users get free support.

  1. Once you click on it, you will be re-directed to https://powerbi.microsoft.com/en-us/support/pro/ 
    2019-05-03 09_16_20-How to create a support ticket in Power BI - Word.png
  2. You can search for the issue. If the issue is already listed, it will display. It will also give you an option to SUBMIT A TICKET
    2019-05-03 09_18_03-How to create a support ticket in Power BI - Word.png

  3.  Click on CONTINUE TO SUPPORT TICKET. You will be redirected to https://powerbi.microsoft.com/en-us/support/pro/ticket/
    2019-05-03 09_19_44-How to create a support ticket in Power BI - Word.png

Once you submit the ticket, you will get an email from support@mail.support.microsoft.com. Someone from the  Microsoft support team will contact you.

jo_brough Visitor
Visitor

Power BI's slicers provide a powerful way to hide rows in a table - but no built-in feature allows columns to be shuffled and sliced in a similar way. That doesn't mean it can't be implemented, however, and in a way that is close to seamless for an end user. Using a layer of measures, we can abstract the columns of raw data from the displayed columns, and allow columns to be dynamically displayed in any position.

Read more...

Jayendran Established Member
Established Member

Introduction

Google Location Tracking

We are all used Google location for whenever we travel into the new areas or find exactly where we are. So we simply turn on the location in our mobile. As soon as we turn on the location google will track our location with exact Latitude and Longitude. Infact google will track our lat and lon for every 3-5 seconds. Considering this amount of data for every one across the world, it's pretty big. 

 

In this article we will see how we visualize our own location data from Google using the Microsoft PowerBI Tool. So, this article is going to combine the power of two big Shots

  1. Google for Data
  2. Microsoft for Technology

Before diving into this article further let see how the final report will look like,

 

Read more...

augustindelaf Member
Member

Capture.PNG

 

In any reporting project, access to data is not enough.
You have to access instantly to its explanations, its insights. Moreover, these insights must be contextual, that means they have to be related to the data they explain. This link between data and insights must be clear, obvious for the human eye, unequivocal.

For that, the ideal chart in Power BI is called the Pulse Chart.

Read more...

Super User
Super User

So, recursion is impossible in DAX, just like "for" and "while" loops are impossible in DAX...

Read more...

Super User
Super User

Everyone knows that DAX does not support traditional for and while looping. But what if it did?

Read more...

Super User
Super User

Resurrecting my old series, "Fun with Graphing in Power BI", this time with ray tracing!

Read more...

Super User
Super User

This article is designed to go with my recent Data Stories Gallery submission, 3 Year Analysis of Gartner Magic Quadrant Leaders for Analytics and Business Intelligence. It's a rather lengthy title I know! Luckily however, the analysis was rather quick and easy. But, I thought that a few more insights could be shared around this than simply what appears in the Data Story Gallery posting or within the Power BI report.

Read more...

Helpful resources

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