Power BI Apps - Audience seems not enough & Power BI REST API doesn't support direct read assignment
CONTEXT: Power BI Premium WS. We have implement this security architecture for a specific Entra Group X: XXX-SemanticModels Workspace: None Sales Semantic Layer: Read, Build XXX-Sales Reporting Workspace: none XXX-Sales App: part of the Audience Report level: Read We currently use CI-CD pipelines to deploy the structure across enviroments (yaml, powershell, Power BI REST API, etc) ISSUE: We have an issue with the last bullet: Report level: Read permission. On one hand, it seems we need this permisson (despite the Power BI App documentation) otherwise users cannot see the content of the App. On the other hand, there's No Report-Level API for "Read" or "Reshare" so everytime we re-deploy a report, this permission is gone. Any advice? TIA
Power BI shows tomorrow's date today in filter
Hello, When I go to the relative date filter and filter by date and press "include today" it shows tomorrow's date. See below. The actual day was 10/29/2019 and Power BI thought that today was the following day. I've looked around in the settings and do not see where I can overrule this. I have auto date/time selected and my computer acknowledges the correct date, 10/29. Where can I change this setting? Or how should I overcome this issue? Any and all help would be greatly appreciated. Thank you.
Dynamic measure formatting (preview) not displaying stacked bar chart totals in correct format
Problem: Stacked bar charts dont display totals in the correct format when using the new preview feature dynamic formatting for measures. See the image below In this example the measure is dynamically formatted to display as a percentage, which it does on the individual segments of the bar. But on the totals in the tooltips it always shows a different format (possibly the original format), and when enabling the column totals it shows a combination of formats as seen at the top of each bar. Measure: Test Measure = COUNTROWS('My Table') Format: "0.0%;-0.0%;0.0%" Please could you help with identifying the issue? I cant turn on column totals on this visual as it is. ThanksReference labels on New Card Visual autoformat numbers (column type: Text) - no way to change it?!
have a New Card Visual where I need to provide a year for reference. Since some of the years are with text (i.e. FY2025), the column has "Text" as datatype. Now, when I insert the year in a reference label, it autoformats to "2K" with no way to change it, since the column type is "Text". The solution for me was to enter Power Query, change the format of the column to "Whole number", Close and Save (with errors). Then I was able to change the format from "automatic" to "none". Then I opened Power Query again and changed the format back to "Text" and closed and saved to Power BI (now with no errors). Then the format was changed. So the conclusion is, that if you are working on an Import model, you will be able to implement this hack, but you are kind of stuck if you are working on an AAS or Live model.
Reference line types of median and percentile not calculating correctly
When adding one of the pre-defined reference line of median or percentile type to a chart the lines are not calculating correctly. They seem to be treating nulls as 0s. Given the dataset: You get a median of 5 and a 90th percentile of 49: When the actual values should be a median of 35 and 90th percentile of 55: The average, minimum, and maximum lines seem to be calculating correctly.
