Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

DATAAREAID (ENTITY) filter that applies to embedded Power BI reports

Hi there

I am working in OneBox environment where i design Power BI reports and then deploy them via VS to environment. I use Aggregated Measure and Data Entities with BOYD approach. 
all nice and clean it works but I need to achieve that when a user changes entity (DATAAREAID) in the UI the data will load data belonging to the new selected entity. 

I found a solution that is similar to what I want to achieve BUT.

this is basically Role level security where DAX expression [DATAAREAID]=username()  is applied for every table that has the entity (DATAAREAID) field. 

what is happening in the background is that all data is loaded into the pbi and then the dax filter is applied

this might work for some fact tables in simple star schema but if you have multiple records for the same id, for multiple entities (DARAAREAID) then when loading the data into DATA moded it will fail because the  1:Many relationships will now work anymore as there are no unique records on the 1 site of the relationship. 

... so what i need is to have the filter already happening in the power query in the M not in DAX once it is loaded.. 

in the development, i used a parameter that I would switch between the entities in power query but if i deploy it via onebox and VS there is no way i can switch the parameter as far i know.

anyone that can help ? any idea is welome


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.