microsoft / microsoft/Analysis-Services

Exclude What-If Parameters from BRARule "ENSURE_TABLES_HAVE_RELATIONSHIPS" (Power BI)

Open
#144 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C#
Stars
732
Forks
433
PR merge metrics
No merged PRs in 30d

Description

Hello!

I'd like to suggest a new feature for this rule.

Usually Parameter tables in Power BI model contain only one column and measure with the following expression pattern:
SELECTEDVALUE('WhatIFParameter'[WhatIFParameter], 5)

One the possible additions to the current Rule definition (UsedInRelationships.Count() == 0) could be: (Columns.Count() > 1)
This condition would show only table with two or more columns.

Best regards,
George

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Locate the BRARule definition for ENSURE_TABLES_HAVE_RELATIONSHIPS and inspect how its current UsedInRelationships.Count() condition is evaluated for Power BI model tables. Done means What-If parameter tables with one column are excluded while tables with two or more columns remain reported by the rule; verify the rule's existing checks if tests are available.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
data-visualization
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.