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 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.
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.
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!
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.
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
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.
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.
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.
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.
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.
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.
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
Google for Data
Microsoft for Technology
Before diving into this article further let see how the final report will look like,
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.
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.