BestPracticeRules

BestPracticeRules copied to clipboard

[Rule Request] Check if any RLS Filter Expression is blank for tables that start with "fact_"

1

Dear all, for our security concept, we aim at creating an additional rule, which checks all model roles if the RowLevelSecurity FilterExpression is blank. If it is blank, we aim...

ViktoriaVrg

Dimension Tables 1 dimension table names should always be in singular 2 All underscores in columns and table names should be replaced with space and type case capitalisation e.g **order_id**...

spidyyinka

should be "Disable auto date/time" instead

MEhrenmueller

Just made it more clear that the BP file needs to have a specific name

erapade

[Rule Request] Per-Model Exceptions to BPA Rules

1

I'm not sure if this is a more of a BPA feature suggestion or a BPA Rule suggestion, but I think this could be done in the rule expression. We...

InsightABI

I added the following Rule to my BPA. I don't want my users to connect to the model directly and instead use one of the perspective. Therefore I need to...

KornAlexander

[Rule Request] To check if "Filter' is used to filter a column in a measure

1

Hi I need to create a rule to check whether a filter condition has been used in calculate to filter a column. Lets say there is a fact table called...

hemant1303

[Rule Request] Hide foreign key columns

1

Good morning, Firstly, I really like the effort the communities to elevate the Power BI development level. Keep up the good job. I'm trying for the first time the BPA...

lbeneyze

[Rule Request] Provide short rule description

1

is there a way to create a rule to detect which fact table columns generate a referential integrity on any particular dimension? Looks like the Vertipaq Analyzer provides the count...

cosminioan

Export/Compile Violation List

1

I'm running the BPA on a variety of models, and looking to create a living catalog of violations, fixes, exceptions/ignores. A simple 'export to Excel' feature may help, so that...

JasonTodd21