need help
13559 TopicsDataset Refresh REST API returns 415 "Model-based dataset" error
Since 2026-08-14, calling the Refresh Dataset REST API (POST /v1.0/myorg/groups/{workspaceId}/datasets/{datasetId}/refreshes) on any dataset in my tenant fails with: HTTP 415 UnsupportedMediaType {"error":{"code":"InvalidRequest","message":"Invalid dataset. This API can only be called on a Model-based dataset"}} This happens even on datasets that refreshed successfully via this exact API for weeks before that date, without any changes to the dataset itself. Manual "Refresh now" via the Power BI portal UI still works fine on the same datasets — only the REST API call fails. What I've already ruled out: Not a client bug — reproduced identically with curl using the same bearer token, bypassing my application entirely. Not just a POST/trigger issue — a plain GET /datasets/{id}/refreshes (listing refresh history) fails with the same error. GET /datasets/{id} succeeds fine and returns "isRefreshable": false, even for a standard Import-mode, on-premises-gateway-connected dataset (targetStorageMode: Abf) that worked correctly before. Not a capacity issue — my Fabric trial capacity shows Active/healthy. Checked Service Health and Known Issues in the Admin Portal — nothing matching. Possible trigger: the issue started the same day I added (then a few hours later removed) two unused Azure AD Application permissions (Tenant.Read.All, Tenant.ReadWrite.All) on my app registration for an unrelated experiment. It's been 3+ days since removing them and forcing a fresh sign-in, and the issue persists. Has anyone else seen this, or does anyone know what could cause isRefreshable to flip to false tenant-wide like this? Happy to share more details (workspace/dataset IDs, full error bodies) if useful.36Views0likes3CommentsHow to make Power BI Slicer to show the latest forecast selected when the report loads
I have a request to show the latest Forecast selected as a default slicer when the report loads.. every 3 months new forecast will come. 2026_F1, 2026_F2, 2026_F3 like that, The slicer is a single select when the report loads the selection should be latest and the user can change the visuals will change accordingly. I use a calculated column in power bi to add a new column that will have values2026_F1, 2026_F2, Latest...... When new forecast comes 2026_F1, 2026_F2, 2026_F3, latest like that.. and i made the default selection as Latest. The user doent want to see the word latest he wants to see the forecast name instead of the workd Latest. How to do it. I know bookmarks is an option but we have so many bookmarks in that report and doesnt want to use that one .42Views0likes5CommentsConsolidation of Data from existing reports
I've created about 20 Power BI reports for 20 different customers. Because the data provided by the 20 customers is different, or provided in different formats, each is it's own report with it's own semantic model. Each one of these reports does carry some common datasets. I now need to consolidate all 20 into one report so that I can pull all the data into a Matrix by Customer and Product are in rows and Month & Year as well as Quarter & Year are in columns, like the individual reports. I started by importing the semantic models one at a time into a new Power BI report. These imported fine, but it also brought in the Common data for each report as well, Like the Date table, and the Product table. I don't need these in there multiple times, just once and I can pull these in separately. I just need the base data, the customers' data, and it won't let me delete the Common tables.Solved34Views0likes3CommentsPowerBI Workspace Not Found" Issue
Hi Team, I am trying to deploy a thin report to a Power BI workspace using a Service Principal. However, I am receiving the error "Power BI Workspace Not Found". The Service Principal has Admin permissions on the target workspace, and I am passing the correct workspace ID in the API request. Has anyone encountered this issue before? Are there any additional permissions, configurations, or prerequisites that I should verify? Any guidance would be greatly appreciated. Thanks.20Views0likes2CommentsIframe continues scrolling after mouse release when interacting with Power BI visuals
Hi Community, I'm experiencing an issue with a Power BI report embedded inside an iframe. Scenario Power BI report is hosted within a custom web application using an iframe. Users interact with report visuals that support scrolling (tables, matrices, slicers, etc.). When clicking and dragging the scrollbar inside a visual, the scrolling continues even after the mouse button has been released. It appears as though the iframe or embedded report is still capturing the drag/scroll event. Expected Behavior Once the mouse click is released, scrolling should stop immediately and control should return to the page normally. Actual Behavior Scrolling persists for a short period or remains "stuck" until the user clicks elsewhere in the report or page. Environment Power BI Embedded / Power BI Service in iframe Browser: [Chrome/Edge version] Report contains tables and matrix visuals with internal scrollbars Custom web application hosting the iframe196Views1like8CommentsPower BI Alternative Front End for Visualisations / Dashboards? (web native)
I’m wondering if anyone has suggestions for using the Power BI data model or DAX to create more web native dashboards for our products. We want something that looks and acts the web instead of PowerBI, but allows some of the benefits of the data model and backend. Either looking at some methods, tools or even a whole new product we can buy to sit over the top. Wish list - Allow creation of a collection of visualisations / dashboards Control styling and layout with HTML/CSS including webfonts Responsive Edit/swap a chart in the layout with the same ease as Power BI. Doesn’t live in something that looks and iFrame. I understand I’m asking for a lot and really bending what Power BI does so it might just be impossible. I’m also open to any alteratnive products that might help.2.4KViews0likes2CommentsPower BI custom connector
I'm building a Power BI custom connector for an OData API and would appreciate some guidance from the community. My connector currently allows users to select a table/entity and load data successfully. However, I'd like to enhance the user experience with two additional capabilities: Filter Selection Dropdown Similar to the Advanced Options available in the built-in Web connector, I want to provide users with a dropdown (or similar UI control) to select predefined filter values before the data is loaded. Ideally, the selected value would be passed as an OData filter parameter to the API request. Is there a supported way to create dropdowns or dynamic parameter selection screens in a custom connector? Back Navigation / Re-selection of Table After a user selects a table/entity, I'd like to provide a way for them to go back and choose a different table without having to restart the connection process. Is there any concept of a "Back" button or navigation flow within Power Query custom connectors? If not, what is the recommended approach for handling multi-step selection scenarios? I've reviewed the custom connector documentation but haven't found clear examples covering these UI/navigation requirements. If anyone has implemented something similar or can point me to relevant documentation, sample connectors, or best practices, I'd be very grateful. Thanks in advance!Solved94Views0likes4CommentsDynamic Refresh Period Per Firm - Date Slicer Shows Global Range Instead of Firm-Specific Range
Hey all, I have a transactions dataset with multiple firms where each firm needs a different data retention period. Firm A needs 12 months of history, while Firm B needs 15 months. Users are scoped to one firm at a time via RLS. The issue: Even though the fact table correctly loads firm-specific months from Snowflake, the date slicer shows the same global date range (15 months) for both firms. Current Setup: Parameters: RefreshPeriod = "12" (default months) RefreshPeriodOverrides = "FirmB:15" (firm-specific overrides) FirmRefreshCaseSQL = generates CASE WHEN FIRM_KEY = [FirmB] THEN -15 ELSE -12 END MaxRefreshPeriod = "15" (max across all firms) Data Loading: Transaction fact table: Uses FirmRefreshCaseSQL in WHERE clause, correctly loads 12 months for Firm A and 15 months for Firm B Calendar dimension: Uses MaxRefreshPeriod, loads 15 months globally Relationships: Transaction[Transaction Date] → Calendar[Transaction Date] (many-to-one, single direction) Transaction[FIRM_KEY] → Firm[Firm ID] (many-to-one) Date Slicer: Bound to Calendar[Transaction Date] Expected Behavior: When Firm A is selected: slicer shows last 12 months When Firm B is selected: slicer shows last 15 months Actual Behavior: Both firms show last 15 months because the calendar dimension is global and doesn't know which dates belong to which firm What I've Tried: ✗ Setting parameter overrides at the report level - didn't propagate to semantic model ✗ Testing with measures - confirmed fact data is correct per firm, but slicer uses calendar dimension 🔄 Current approach: Adding a "Firm-Date Availability Bridge" table with distinct (FIRM_KEY, Transaction Date) combinations to enable filter propagation: Firm → Bridge → Calendar Questions: Is a bridge table the right approach for this scenario, or is there a simpler pattern? Should I consider making the Date↔Transaction relationship bidirectional instead? (Concerned about RLS implications) Are there any DAX-only solutions that don't require model changes? Has anyone solved firm-specific date filtering without loading separate datasets per firm? Any guidance would be appreciated! Thank you!70Views0likes3CommentsCan we improve relationship arrow rendering in the semantic model view?
There are multiple issues with the way relationship arrows are rendered, and this image displays a few of them: (Note: I am using the web interface, via Edge.) Is there anything I can do to combat this confusing display pattern? An arrow that points ambigiously is worse than no arrow at all. If anyone in power is reading: please either give us more control over how these are rendered or make them behave logically. Example: in the first and last relationships shown above, I know that the arrow has rotated because the connecting lines are not perfectly aligned, but these lines should automatically align vertically as the others have and the arrow should only rotate if there are visible horizontal connectors extending out its sides.104Views0likes5CommentsI Can't Know Who Has Access To A Report Via APIs
Hello. I'm an admin of a Power BI environment. We need to know exactly who has access to all reports through workspace membeship, shared links and Apps. We have all the APIs that can show who has access through workspaces and shares, but there seems to be a huge flaw when it comes to App Audiences. For example: An App has two reports (R1 and R2) and two audiences (A1 and A2) A1 can see R1 but not R2 A2 can see R2 but not R1. Although we will be able to list the members of A1 and A2, we won't be able to tell which audiences they were in and therefore won't know if they have access to R1 or R2. All the aboove means we can't know for sure who has access to R1 or to R2. Is there an API that will provide this information that I have missed?Solved143Views0likes5Comments