Report Page Tooltip – Revolution in Visualization of Power BI

Very exciting feature that is added in the most recent version of Power BI Desktop March 2018 is Report Page Tooltips. This is a specific type of tooltip which can be a report itself. which this feature you can have your drill down report designed separately, and then with hovering on a chart, you can Read more about Report Page Tooltip – Revolution in Visualization of Power BI[…]

Power BI Embedded; Power BI in a Custom Application

Power BI leverages a very powerful method of sharing named Power BI Embedded. This method of sharing is important because of mainly two specific features of it. With this method, you can share Power BI content in your custom application, and you can share it with your custom application users, regardless if they have Power Read more about Power BI Embedded; Power BI in a Custom Application[…]

Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure

One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]

Unleash Security Patterns in Power BI; Webinar Recording and Materials

Thanks to all attendees of my Power BI webinar last Friday. I hope you all enjoyed it. I explained a number of the most common row level security patterns in Power BI with some DAX expressions, in this post you will find the description of webinar, recording, and link to all demos and materials. Although Read more about Unleash Security Patterns in Power BI; Webinar Recording and Materials[…]

Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model

Previous versions of Power BI Helper had some features related to the visualization part and the modelling part of a Power BI file. This latest release of Power BI helper, can export the entire M or Power Query script into a file or into clipboard. Sometimes, especially when the number of queries in the Power Read more about Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model[…]

Embed Power BI in SharePoint Online; Office 365 Integrated Sharing

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[…]

Power BI Desktop; Getting Started – Part 1

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[…]

Ultimate Sharing Strategy: Power BI Apps

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[…]

List.Accumulate Hidden Gem of Power Query List Functions in Power BI

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[…]

Expression Dependency Tree: New Feature of Power BI Helper

I’m excited to share the news with you that we have added a new feature in Power BI Helper; Expression Tree. Expression Tree will expand the tree of expression for a Measure or calculated column, you can see what other measures are used to create this expression, and where other measures, calculated columns, or even Read more about Expression Dependency Tree: New Feature of Power BI Helper[…]