Org vs. Workspace Apps - permissions & embedding
We are preparing to rollout Power BI to our organization and are determine whether we should guide users to Organizational vs. Workspace apps. By all accounts, org apps seem the way to go but I'm running in to 2 issues: Org apps do not allow users "share with the entire organization" as an option - is this a setting i am missing somewhere? Org apps cannot be embedded in sharepoint. I have tried every type of link, code, etc. but only workspace apps will embed. is there any way to overcome these two issues with org apps?
Combining Two Power BI Dashboards into One Report
Hello, I currently have two separate Power BI dashboards/reports, each connected to its own data source. I don't need to merge or combine the underlying data sources. What I'm trying to achieve is having copy the pages with my visualizations so users can access everything in one place. Is there a way to bring the pages/visuals from one report into another without having to rebuild them manually or merge the datasets? Ideally, I'd like to keep the existing data connections and simply consolidate the reporting experience. Has anyone done this before, and what would be the recommended approach? Thanks!
Date picker incorrectly shows unavailable dates warning when the date table ends on Today
I am using the new Date picker slicer with a continuous date table containing one row for every date from 4 January 2010 through Today. The Date picker is configured as follows: Date is in: Last Value: 1 Unit: Years From: Today Offset by: 0 Years Date Table Refresh Behavior The DateDim table is a calculated table, and the semantic model is refreshed daily. As a result, the date table is recalculated on every refresh, with its maximum date dynamically set to `TODAY()`. Therefore, the date table automatically extends to include the current date after each daily refresh, rather than having a fixed end date. During testing, I verified that the semantic model had refreshed and the maximum available date matched `TODAY()`. When this relative range is applied, the Date picker displays the following warning: "Some dates in the selected range aren't available in the data." However, the complete selected range is available in the date table. For example, during my test: Today: 2 November 2026 Maximum available date: 2 November 2026 00:00:00 Selected start date: 3 November 2025 Selected end date: 2 November 2026 Missing dates: 0 Duplicate dates: 0 Dates with a non-midnight time value: 0 I also validated that: The unfiltered maximum date is equal to TODAY(). The complete selected range is available. There are no visual-level, page-level, or report-level filters restricting the date column. There are no synced date slicers. The issue also occurs with a newly created Date picker on a blank report page. Additional tests I performed the following comparison tests: When I select the same start and end dates manually, the warning disappears. When I change the relative anchor from Today to Last date, the warning disappears. When I extend the date table to include TODAY() + 1, the warning disappears. The relevant calculated table is: DateDim = VAR StartDate = DATE ( 2010, 1, 4 ) VAR EndDate = TODAY () RETURN SELECTCOLUMNS ( CALENDAR ( StartDate, EndDate ), "Date", [Date], "DateId", VALUE ( FORMAT ( [Date], "yyyymmdd" ) ) ) Based on these tests, the Date picker may be validating the Today boundary using the current date and time, or it may be expecting the next day's midnight as an exclusive upper boundary. Expected Behavior When the date column contains every date through Today, selecting Last 1 Year from Today should not display the unavailable-dates warning. The relative selection and an equivalent manual selection should produce the same result and warning behavior. I have attached a sample Power BI report file that reproduces the issue for reference. Could Microsoft please confirm whether this is a known issue with the new Date picker slicer? Is there any required configuration or recommended fix to prevent this warning when the date table already contains every date through Today?
How do you handle subtotals that don't equal the sum of child rows?
Hi everyone, I'm looking for advice on how others handle a reporting scenario involving distinct counts in a matrix visual Electronics 150 Online 120 Retail 80 Wholesale 40 So user would expect 120 + 80 + 40 = 240 and wonder why total is only 150. The reason is that the value is a Distinct Count of Customers. The same customer may appear in multiple sales channels, so the subtotal is recalculated at the category level rather than being the sum of the visible rows. My measure DISTINCTCOUNT(CustomerID) is a non-additive measure, so parent totals don't equal the sum of their children. My questions is how do you typically present this to business users and do you leave the matrix as-is and provide an explanation? Thanks
How to reslove Preview Error in Power BI
Hi Friends. I am connecting to dataverse from Power BI. I have loaded opprtunity table from the list. That is big table with multiple columns. I want select cloumns using Choose Columns. Unfortunately i am facing preview error. Can you please help how to resolve this issue.semantic model design and DAX
Hi all, I need some help to resolve some issue. Currently I have 4 tables. there is service table which contains all service approved. There is a table called transfer which recorded when a service is transferred from one owner to another owner within the same state or from other state. There is a table called complaint which records all complaints a service received There is a table called compliance action which records all compliance action which a service being issued. The purpose of the project is to measure what is the impact when a transfer of service happened. it is measure by #complaint and # compliance action. In the semantic model, I cannot link the transfer table with the complaint or compliance action table directly since the multiple transfer with multiple complaint/multiple compliance action. What can I do to overcome this design and be able to measure # complaint before and after a transferred occurred # compliance action before and after a transferred occurred. the current measure below does not take a factor into the account where there is multiple transfer and multiple compliance action. eg there are 2 transfer, 4 compliance action. instead of showing 4 compliance action, the result will return 8. Is it possible to create a workaround solution to resolve this issue? Compliance actions = countrows( filter( 'DimCompliance Action', 'DimCompliance Action'[Service ID] in VALUES ('DimTransfer'[Service ID]) ) Compliance action Before Any Transfer = CALCULATE( COUNTROWS('DimCompliance Action'), FILTER( 'DimCompliance Action', 'DimCompliance Action'[Date compliance action issued] < CALCULATE( MIN(DimTransfer[Actual Transfer Effective Date]), ALLEXCEPT('Service Fact', 'Service Fact'[Service ID]) ) ) ) )Matrix with "Switch values to rows" – how to bold only one measure row?
Hi everyone, I'm building a Matrix visual in Power BI Desktop with several measures displayed as rows (Values → Options → "Switch values to rows" = On). Columns are fiscal years (FY2026–FY2030). Goal: make ONLY the #sale_B row bold – both the row header and its values – while #sale_A and #sale_C stay regular. What I've tried: 1. Format → Specific column → Series = #sale_B: this card only offers Text color, Background color, Alignment, Display units and Value decimal places. There is no font style / bold option. 2. Conditional formatting (Cell elements): supports background color, font color, data bars, icons and web URL, but not font weight. 3. Values → Font → Bold: applies to all measures, not just one. 4. Workaround: a text measure that replaces digits with Unicode bold characters (U+1D7EC–U+1D7F5). It looks bold, but the output is text, so alignment, number formatting and Excel export break, and the row header is still not bold. Questions: - Is there a native way to bold a single measure (values + row header) in a Matrix? - If not, what is the cleanest workaround you would recommend (different model structure, calculation groups, another visual, etc.)?
