Connect directly to a specific SharePoint Folder - not the entire site
PROBLEM: I am workin on a few projects for a specific site in our sharepoint tenant. This site is extremely lare with over 3.5TB of data. I need to run a few reports that are specific to individual folders in the site. The problem I have is that when I connect through Power Query, it forces the entire site contents to be loaded and does not allow me to hit the specific folder without first hitting the entire sharepoint site. So this mean I am first loading every folder on the sharepoint site and then filtering to a folder. The causes the reports and refreshes to take an excruciatingly long time to load and refresh because it is not just refreshing the folder but the entire site data in the query. REQUEST: Is there a way to bypass connecting to the entire site and load directly into the folder I need?
Visualizations and Data panes missing from Report view – September 2026
Hi, I'm using Power BI Desktop version 2.158.1177.0 (September 2026) and the Visualizations pane and Data pane are completely missing from Report view. The Show panes section in the View tab only shows Filters, Bookmarks, Selection, Performance analyzer and Sync slicers – no option to bring Visualizations or Data back. Also in Power Query Editor the Column Quality, Column Distribution and Column Profile checkboxes are missing from the View tab entirely. I tried installing July 2026 and June 2026 from the archive – same issue on both. I also tried the Microsoft Store version – same problem. Is this a known bug? Has anyone found a fix?
Personal bookmarks not displaying in Service
Is anyone else experience bugs with Personal Bookmarks in the last week or so? I have a number of users who are viewing reports in the service who have created their own bookmarks that have historically been working fine. In the last few days, when they click on their personal bookmark, nothing happens - you can click on the bookmark name, but the visual/page does not change. I have seen the bug too, but when I refresh my browser, it usually starts working again but that solution isn't consistent with others. It's happening with bookmarks in multiple reports/connected to different models.Reports shared via dashboard not showing up in Recent/Favorites areas
I shared a dashboard with several reports on it. And multiple users have experienced viewing reports, favoriting them, and then having them not show up on the Recent or Favorites areas on the Home page or Browse page. Once I shared the report with them directly and not only via sharing the dashboard, it then appeared in both areas of Power BI Service. This is incredibly annoying as sharing via dashboards is how I share most content so that I do not need to go to multiple reports to share with users and only have to share one dashboard. (We do not use Apps for the most part, just dashboards. So that's not going to be a solution). Has anyone else experienced this? I feel like it is a bug, but can't find any information on this scenario anywhere.
Power BI Paginated Report – Redirect to Web Application URL in the Same Tab
Hi Everyone, We have embedded Power BI Paginated Reports into our web application, and the embedding is working as expected. However, we have a requirement in one of our paginated reports where certain IDs are displayed as clickable links. When a user clicks on an ID, we need to redirect them to the corresponding module/details screen in our web application, with the selected ID passed in the URL. We tried configuring the action using: Text Box Properties → Action → Go to URL This works and successfully redirects to the required URL. However, the URL is opening in a new browser tab/window. Requirements We have the following requirements: When the user clicks on an ID in the paginated report, the corresponding web application details page should open in the same browser tab where the report is currently embedded. Since the user is already logged into our web application, they should not be prompted to enter their credentials again when redirected to the application details page. The existing authenticated session/login should be maintained. Current behavior Paginated Report → Click ID → Opens Web Application Details page in a new tab → User may be prompted to log in again Expected behavior Paginated Report → Click ID → Redirects to Web Application Details page in the same tab → Existing web application authentication/session is maintained → User can directly view the details for the selected ID Is there a way to configure the Go to URL action in a Power BI Paginated Report to: Open the URL in the same browser tab, rather than opening a new tab/window? Preserve the user's existing authenticated web application session/SSO, so that the user is not prompted to log in again? This is particularly relevant because the Paginated Report is embedded within our web application, rather than being accessed independently. Any guidance on the recommended approach or configuration would be greatly appreciated. Thank you!
User created Sharepoint Calendar as default view, now I can't find the list?
Hello! Basically, I used Get Data --> sharepoint online list --> 2026 Events Calendar Got all the fields. EZ PZ. Since then, they created a Calendar view, which is nice, they can edit the records right there and it's now the default view. Because of this, now when I go to the dataset I created last week, it fails and defaults to the Calendar View, which only uses 4 columns of the 25 ish in allitems. However, I can't find that list anywhere except those 4 columns. I did find the URL, but that doesnt seem to help. I was considering using the API, but it is a last resort. Any thoughts?
Fabric data agent fails for a shared read-only user, but works for developers
Hi everyone, I've created and published a Fabric data agent connected to a Power BI semantic model. My fellow developers and I can successfully ask questions in both Fabric and Microsoft 365 Copilot. However, one test user consistently receives an error in both environments, using the same questions that work for us. In Fabric, the error is: "An error occurred. Please try again or ask a new question below." Expanding the response only shows the same message. In M365 Copilot, the agent reports that the data service is unavailable and it cannot access the underlying dataset. We have confirmed that the published agent is shared with him and that he can open it. He has Read permission on the underlying semantic model, his RLS access is configured, and he can view data in existing reports connected to that exact model. His account is also allowed to use Fabric Copilot. The relevant differences are that he has no workspace role in the workspace hosting the agent and only has Read access, while the developers have broader permissions. According to the following documentation, Read permission on the semantic model should be sufficient, and workspace access should not be required for interaction through a data agent: https://learn.microsoft.com/en-us/fabric/data-science/data-agent-sharing Is an additional permission or setting required for users accessing a published agent through item-level sharing? Are there any known issues with this scenario? Where can we retrieve a more detailed error or correlation ID? The current message does not explain which part of the request is failing. Thanks!
LargeModelMovedAcrossRegions error after accidentally activating Fabric trial - dataset inaccessible
Hi, I had an active Power BI (Pro) trial working normally. While configuring a date range filter/slicer, I accidentally interacted with a Data Alert option, which activated the Microsoft Fabric trial as well. Since then, my trial countdown reset to 59 days combined (Power BI + Fabric trial shown as one). Right after this, my published report started showing this error when trying to load the semantic model: "error":{"code":"LargeModelMovedAcrossRegions","pbi.error":{"code":"LargeModelMovedAcrossRegions","parameters":{"regionName":"South Central US"} My workspace capacity is currently a Fabric Trial assigned to "West US", while the error references "South Central US" as the model's original region. This mismatch appeared right after the accidental Fabric trial activation. This is a production dashboard used by my client's team (embedded in Teams/SharePoint), and it has been inaccessible since this happened. Could you please help me either: 1. Move/reassign my semantic model back to a region matching my current capacity, or 2. Advise how to resolve this region mismatch without losing the existing semantic model (measures, relationships, Power Query steps). Tenant: INTERNATIONAL LOGISTIC SERVICES SAS Account type: Free/Trial (Power BI + Fabric trial) Workspace: My Workspace Thank you for your help — this is time-sensitive as it's a live client dashboard.
[DataSource.Error] Credentials are required to decrypt this workbook
Hi all, I got this error while trying to open an Excel workbook in Company SharePoint. The file isn't password-protected, there are no sensitivity labels. Not sure if it has anything to do with Purview encryption but that seems unlikely. The solution proposed in this thread didn't work for me. Haven't found any other solutions in the forums. Any other solution to try ? Thanks in advance
How can I show only dimension values that exist in the fact table used by the current page?
Hi everyone, We are currently working on a Power BI report with a dimensional model, and we are running into an issue with our slicers. We have several dimension tables that are used in slicers. Ideally, we only want to show dimension values that actually exist in the fact table(s) relevant to the current page. At the moment, however, the slicers show all values from the dimension tables, including values for which there are no corresponding records in the fact table being used on that page. We tried solving this by creating a measure that checks whether there are fact records for the selected dimension value. The problem is that our report contains multiple fact tables. The fact table being used can differ depending on the page, and some pages can even use multiple fact tables. For example: Page 1 uses FactTable A Page 2 uses FactTable B Page 3 uses FactTable C and FactTable D Because of this, creating one generic measure that checks all fact tables does not seem to work correctly. A dimension value may exist in one fact table but not in the fact table(s) relevant to the current page, which means the slicer can still show values that should not be available. Our goal is: For each page, only show dimension values in the slicer that have corresponding records in the fact table(s) used by that page, while respecting the current filter context. Has anyone encountered a similar scenario? I get the feeling that this is a very common issue for developers. Thanks in advance!
