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

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

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

Posted by on Apr 11, 2019 in Power BI, Power BI Helper | 3 Comments

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

Register Power BI Helper in Your Tenant

Posted by on Apr 11, 2019 in Power BI Helper | 4 Comments

This article explains the setup instructions to work with the Service tab of 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 BI ...

Read More

What Is the XMLA Endpoint for Power BI and Why Should I Care?

The news about XMLA endpoint connectivity to Power BI datasets is now all around the internet after the public preview announcement of that last week. However, I realized that the XMLA endpoint term is still too technical for many Power BI report developers. Many people come to me asking what exactly is XMLA endpoint, and ...

Read More

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

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

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

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

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

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

Combining Dimension Tables in Power BI using Power Query: Basics and Foundations of Modeling

The article that I wrote earlier this week about the shared dimension had a lot of interest, and I’m glad it helped many of you. So I thought better to write about the basics of modeling even more. In this article, I will be focusing on a scenario that you have all faced, however, took ...

Read More