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

Posted on February 21, 2018 by Reza Rad

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

Posted on February 19, 2018 by Reza Rad

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

Posted on January 29, 2018 by Reza Rad

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

Dynamic Date Range from Slicer

Posted on January 26, 2018January 26, 2018 by Philip Seamark

A recent post on a community.powerbi.com forum asked if it was possible to show a slicer of months, and configure a report so when a user selects a single month from the slicer, visuals will show data for a date range relative to that selection e.g. the preceding 10 months of data. If a user Read more about Dynamic Date Range from Slicer[…]

Creating Machine learning Development and Production Environment in Power BI

Posted on January 11, 2018 by Leila Etaati

There is need to isolate the development and production environment in most of all projects. Setting up these environments help us to deliver a more reliable product to our customers. Machine learning projects also need a development, Test and Production environment. In this post, I am going to show you how we can do Read more about Creating Machine learning Development and Production Environment in Power BI[…]

Power BI – Banding and stripes in charts

Posted on January 11, 2018January 12, 2018 by Philip Seamark

This blog will show a technique that can be applied to certain charts allow banding or stripes to help highlight data. This could be horizontal bands to help show data above or below a certain threshold, or this could be vertical bands to help highlight ranges of data by time. In both cases, using What-If Read more about Power BI – Banding and stripes in charts[…]

Power BI Desktop; Getting Started – Part 1

Posted on January 8, 2018September 22, 2020 by Reza Rad

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

Expression Dependency Tree: New Feature of Power BI Helper

Posted on November 29, 2017November 29, 2017 by Reza Rad

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