In this article, you’ll learn about another method of sharing called Embed in SharePoint online. Embedding in SharePoint online is an excellent method to share Power BI content through a SharePoint portal. Because Power BI and Office 365 accounts are bound to each other, this method of sharing is prevalent for SharePoint users. You can Read more about Embed Power BI in SharePoint Online; Office 365 Integrated Sharing[…]
There are some reasons that I chose Power BI Desktop for the very first demo of this book. Power BI Desktop has three components all in one (Power Query, Power Pivot, and Power View), it can upload directly to Power BI website, and it is a recently released product with many shining features. In this section I Read more about Power BI Desktop; Getting Started – Part 1[…]
You’ve learned previously about some of the methods of sharing content in Power BI, such as Workspaces and Dashboard Sharing. In this article, I’ll explain everything about the Power BI Apps, a mechanism to share the content in Power BI in a way that has security and governance together. Power BI App used together with Read more about Ultimate Sharing Strategy: Power BI Apps[…]
There are a number of List transformations available in Power Query’s graphical interface. However, the number of functions in the graphical interface is very limited. In this post, I’m going to explain about a function that is really powerful and is not yet listed in the graphical interface. List.Accumulate is a function that loops through Read more about List.Accumulate Hidden Gem of Power Query List Functions in Power BI[…]
In previous posts, I covered some methods of Dynamic Row Level Security including Row Level Security user based, With Manager Level Access, and also with User and Profiles as a many to many relationships. In this post, I’m going to cover another common scenario for row level security; Organizational hierarchy for security. Through organizational hierarchy Read more about Dynamic Row Level Security with Organizational Hierarchy Power BI[…]
The Dynamic RLS topic is getting a good response in my blog post, so I intend to write about other types of scenarios that a security would be required. In this post, we are going to look at another type of security which deals with users and their profiles. Sometimes you have a user part Read more about Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship[…]
It’s been a while since the last post about Power BI REST API. I have written previously about how to get the REST API, and use it in your application, how the authentication works, and things such as embedding content, and data source management. In this post, I’m going to explain one of the functionalities Read more about Integrate Power BI Into Your Application: Part 6 – Real-time Streaming and Push Data[…]
Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Column? What situation should we use each of these? and on the other hand, what is the difference of creating column here, Read more about Measure vs Calculated Column: The Mysterious Question? Not![…]
Earlier this month (September 2017), in the new version of Power BI Desktop, a new type of chart announced; Ribbon Chart. The very first look and feel of this chart are similar to Stacked Column Chart. The question that might come into your mind is that; why another way of showing the same thing? The Read more about Ribbon Chart is the Next Generation of Stacked Column Chart[…]
A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through Read more about Basics of Value Structures in M – Power Query Formula Language[…]