Skip to main content

46 posts tagged with "Power BI"

Microsoft Power BI Workspaces, Semantic Models, Reports, Row-Level Security and Refresh in the Power BI Service

View All Tags

Fixed: "This User Is Not Configured for Any Row-Level Security Roles" in Power BI

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

Testing a Power BI report as an approver showed This user is not configured for any row-level security roles. Add the user to a role or test another user to validate role definition., and every visual said This visual contains restricted data. The model's roles were defined but had no members yet. Adding the approvers' security group to the role fixed it.

Fixed: Power BI Data Labels Show 45 Instead of 44.50

· 4 min read
Jagdish Kumawat
Founder @ Dewiride

A Power BI bar chart labelled one department's 44.50 overtime hours as 45, and another's 29.50 as 30. The numbers were right underneath: the labels were rounding. The measure's format was General, which lets each visual choose its decimals. Setting the measure to Decimal number with two decimal places made the labels read 44.50 and 29.50.

Fixed: "Data Label Font Reduced" on a Power BI Visual

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

After I turned data labels on, a Power BI bar chart showed warning triangles in its format settings: Data label font reduced, Axis font reduced and Legend font reduced. The tooltip said This visual is responsive. To return the data label font to its original size, enlarge the visual. I had shrunk the report page to 1280 by 720; going back to the default 1920 by 1080, with visuals sized to match, removed the warnings.

Fixed: Apply Security Filter in Both Directions Is Missing in Power BI

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

I needed Apply security filter in both directions on a Power BI relationship, for a row-level security rule. The checkbox wasn't in the dialog: Power BI had made the relationship One to one (1:1), because the data at that moment had one row per value on both sides. Setting the cardinality to Many to one (*:1) made the checkbox appear.

Fixed: Power Query Shows [List] for a SharePoint Choice Column

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

Power Query showed [List] in every cell of a SharePoint Status column, where I expected Approved, Rejected or Submitted. In SharePoint, the column turned out to be a Choice column with Allow multiple selections on, and no choices defined. Turning multiple selections off, and adding the three choices, made Power Query read it as text.