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

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

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

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

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

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

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

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

Jayendran Established Member
Established Member

This article is actually the continuation of my previous article where we saw how to call Power BI API's with in Power BI itself with some Powershell scripts, new API , M-queries and Automation. This is the second part where I'll explain how to create a report out of it and configure gateways & alerts and manage the alerts with the help of PowerPlatforms such as Microsoft Flow.As usual through out this article also I'll tell you lots of Tips & Tricks Smiley Wink

 

Gateway_monitoring.jpg

Read more...

Jayendran Established Member
Established Member

As a PowerBI administrator, it's always difficult to monitor the on-premises gateways within our organization, especically when the number of gateways has been growing rapidly. Today I'm going to explain how you can effecitivley administrate and monitor those gateways in PowerBI itself. Along with that, I'm going to give lots of Tips & Tricks

 

Gateway_monitoring.jpg

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

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

YasinShtiui Frequent Visitor
Frequent Visitor

Imagine you are the owner of a local restaurant and you’ve had modest success with a marketing coupon campaign in the past. You sent out some coupons through the local mail and ended up noticing an uptick in business over the next few weeks. Now you’re wondering which customers you should target next. Additionally, you’d like to know if there’s anything you can do to analyze the coupon campaign with the goal of maximizing benefits and revenue while minimizing costs. Cost-benefit analysis, further referred to as CBA, is one such analytical tool. Now when building binary prediction models using AutoML in Power BI, the resulting report allows you to use CBA with your data.

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

jfeil Member
Member

Ashleigh McGovern develops strategy, raises money, and crafts communications for the Center for Oceans at Conservation International (CI). Among other things, she’s responsible for driving innovative solutions with CI's global teams, partners, and donors to improve ocean health.

Spoiler
 
Read more...

catdor Frequent Visitor
Frequent Visitor

Recently we announced the capability of creating Machine Learning models directly in PowerBI. This is powered by automated machine learning from Azure. 

 

You can create an ML model based on your data with a few simple steps using this new capability, so this post aims to provide some light on the next steps, model performance and application, and provide a few tips about the reports. 

 

Read more...

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

If ALL your Power BI Dataflows refreshes are failing, the details explain below what might be the possible cause.

Read more...

ruthpozuelo
Advisor

You have millions of rows of data stored in your data warehouse, you have it accessible and available for business users and report users, but how do you effectively tell a story using all that data? How do you unlock the secrets and the potential your data has?

 

Check this blog post to get a summary of the webinar I did with Charles Sterling on the Power BI YouTube channel where you will learn tips & tricks on how to effectively visualize your data, the do’s and don’ts and how to present your data so questions can be asked and get answered in the same report.

Read more...

Helpful resources

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