Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2

Posted on April 16, 2019 by Reza Rad

In the first part of this series, you learned how to create an exception reporting for a column in a table using Power Query in Power BI. In the second part, you learned how to initiate that process for all columns in a table. This article continues the section one of creating exception reporting for Read more about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 2[…]

Applied more Analytics on your data with Key Influencer Visualization

Posted on April 15, 2019April 23, 2019 by Leila Etaati

In this post, I am going to demonstrate a new visualization that has been released by the AI team in Power BI in recent months. Before showing off the nice features, there are some key points about this visual. http://datascientistyuyuria.blogspot.com/2017/06/ It can be used by Data sciences, Data engineer and End users. It is easy Read more about Applied more Analytics on your data with Key Influencer Visualization[…]

Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1

Posted on April 15, 2019April 22, 2019 by Reza Rad

Previously, I have written about using Power Query transformations and functions to create an Exception report for Power BI. However, the method I mentioned there, was only doing the exception handling based on one column. In this article, I’m explaining how to do exception reporting for all columns in the entire table. There are a Read more about Exception Reporting in Power Query and Power BI; Part 2 Catching Error Rows for All Columns in the Table Section 1[…]

Copy workspace, Publish to Multiple workspaces, Download all PBIX files, and much more in Power BI Helper April Edition

Posted on April 11, 2019 by Reza Rad

In RADACAD we do our best to improve user experience using Power BI every single day, and throughout that experience, we add more and more functions to Power BI Helper. The newest version of Power BI Helper comes with break-through functions such as connecting to service. Documenting all service objects such as workspaces, datasets, dashboards, Read more about Copy workspace, Publish to Multiple workspaces, Download all PBIX files, and much more in Power BI Helper April Edition[…]

Register Power BI Helper in Your Tenant

Posted on April 11, 2019February 2, 2021 by Reza Rad

This article explains the setup instructions to work with the Service tab of the Power BI Helper. Download Power BI Helper from here. Power BI Helper is a third party application, and any third party application if wants to connect to your tenant, needs to be authorized. You need to give permission to the Power Read more about Register Power BI Helper in Your Tenant[…]

Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI

Posted on April 1, 2019April 2, 2019 by Reza Rad

I have previously written about What dataflow is and scenarios of using it. I also wrote an article about Computed Entity and the important role of that for performance and data lineage. However, a Computed entity is a premium-only feature. There are sometimes that you don’t really need premium functions of Power BI, and only Read more about Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI[…]

Barcode Scanner with Microsoft Power App

Posted on March 26, 2019 by Leila Etaati

As starting my Power Apps learning journey from the last 6 months, I presented a session on Power Apps in Microsoft Ignite Sydney 2019, In that session, I demonstrated some of the features for Power Apps. One of the features that was interesting to me was Barcode Scanner for web browser available in the Preview Read more about Barcode Scanner with Microsoft Power App[…]

Performance Design Tip for Power BI: Be Careful of Dates

Posted on March 26, 2019March 26, 2019 by Reza Rad

I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea why!? In this article, I will show you one Read more about Performance Design Tip for Power BI: Be Careful of Dates[…]

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 2

Posted on March 21, 2019 by Reza Rad

In the previous post, you learned about the challenge of security when Implementing it using multiple positions scenario combined with organizational hierarchy. We started to implement the solution using DAX in row level security. This post is the second part of the solution. Prerequisite The sample dataset for this example can be downloaded from here. Read more about Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 2[…]

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 1

Posted on March 19, 2019March 22, 2019 by Reza Rad

I have written previously about Dynamic Row Level Security, and some of the patterns of it. Two of the most common patterns that I explained were; Organizational Hierarchy, and Many to Many situations of users and profiles. Recently I came across a couple of questions, which persuaded me to write about another pattern of dynamic Read more about Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-to-Many Relationship – Part 1[…]