Power BI add-in for PowerPoint stuck on "Loading..." - tenant-specific, all accounts affected
Hi all, I'm hitting a wall with the Power BI add-in for PowerPoint and I've run out of things to test. Hoping someone recognises this. THE SYMPTOM When I click Insert > Power BI in PowerPoint desktop, the add-in loads forever - the spinner never finishes, and I never get the field to paste a report URL. Sometimes after a while it shows "We couldn't get the information needed to start this add-in". THE KEY FINDING This is tenant-specific, not machine-specific: - Any account from our tenant → add-in never loads (tested on multiple machines, including a brand new account) - An account from a different tenant, on the SAME machine → add-in works fine So the machine and the Office installation are demonstrably healthy. ALREADY RULED OUT - WebView2: installed, complete (152.0.4191.53), msedgewebview2 processes start normally - Office: full Online Repair performed - Accounts: three different accounts across three tenants, plus a newly created one - Windows profile: tested on a fresh profile - Network: tested on mobile hotspot, DNS resolves, TCP to app.powerbi.com succeeds, no proxy configured - Endpoint agent: Cisco Secure Client service stopped for testing - Office cache and registry: Wef folder and registry key deleted and rebuilt - Add-in: removed and re-added - Hardware graphics acceleration: toggled both ways - WIP: presentation file verified as unencrypted, no protection markers - Tenant settings: Office Store access enabled, nothing in Blocked apps, nothing deployed in Integrated apps - Entra sign-in logs: no entries at all at the moment of the attempt, suggesting the add-in never even reaches the authentication stage QUESTION Given that it's consistent across every account in one tenant and works instantly for an account from another tenant, what tenant-level setting could cause the add-in to never retrieve its manifest? Is there something beyond the Office Store toggle and Integrated Apps that needs to be enabled? Any pointers appreciated - happy to provide Request IDs or run further diagnostics. Thanks
Unable to see PowerBI Activator Alerts
I think I created an alert as a test and now I'm getting daily alerts in Teams from Activator. I tried to turn the rule off, but the link takes me to a Power BI app space I don't use, and I just see an error message. I tried to stop the Teams messages by deactivating the bot and now I get daily emails from Activator. I don't see any rules on the report that I made the test alert on either. How do I turn this off? One day I might actually want to use Activator alerts but I can't even manage them right now....and I work at Microsoft
Azure DevOps pipeline to replicate Power BI report changes for various repositories (PBI workspaces)
Hello, here is my business request: -> we are having data from various countries and would like to have dedicated Power BI workspace for data from each country -> it will help us with permissions management, will clearly separate the data,... And technical setup so far looks as the following: -> as semantic models will have the same schema (table names, metric names), it means, that semantic models within each workspace will be using slightly different SQL query (which will gather data for the respective country) -> it's true, that maintenance of semantic models for multiple workspaces may be then be a little bit longer (as we will have to adapt changes for each workspace), but changes for semantic models are not frequent and usually we do bulk of changes together But I am now dealing with the technical question and what would be the best practice for development of Power BI reports, where we would like to reduce amount of duplicated work. Below is my idea for technical implementation: -> PBI reports are developed for one workspace within Azure DevOps repository, then merged through Pull request and then published into PBI workspace through Source control integration in PBI -> and I would like to have Azure pipeline, which will listen to the Pull request merge (basically any change in the master branch of that repository) and then will create similar Pull request in another repository (which is linked to another Power BI workspace), while replicating all the adapted changes for reports -> as was mentioned, schema of semantic models is the same between workspace, so it's only important for replication of Pull request with changed reports to keep proper connection (from Power BI report to semantic model), everything else can be simply copied => and my question really is, if you think, that this could be the right approach (having Azure pipelines to replicated PBI report changes into multiple repositories) and if yes, whether you could suggest to me some working Azure DevOps YAML pipelines examples ? many thanks in advance for any thoughts or suggestions
Power BI Service: DM_GWPipeline_Gateway_MashupDataAccessError on one report
Hi everyone, We’re seeing the following error in the Power BI Service (this error does not occur in Power BI Desktop). Context: Our workspace contains several reports that all use at least one Excel file as a data source. The Excel files are accessed using Web.Contents with a SharePoint link. This setup has worked successfully for about three years and still works for most reports. However, one report fails on every refresh due to an access problem to one of the SharePoint Excel files. The same file is also used in another report; the queries and authentication are identical, and that other report refreshes successfully. So the excel file normally cannot be the problem (?) Important observation: the error contains "/_api/contextinfo" appended to the SharePoint URL — this suffix is not present in the actual query URL in the failing report. We have a gateway configured, but it normally applies only to on‑premises sources (e.g. SQL). The web links are authenticated via cloud credentials (OAuth2) and should not be routed through the gateway Error (unchanged): Fehler bei der Datenquelle{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Web: Request failed: https://xx.sharepoint.com/sites/xx/Shared Documents/xx)/xx/xx/xx/xx_xlsx/_api/contextinfo"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10122"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://xx.sharepoint.com/sites/xx/Shared Documents/xx)/xx/xx/xx/xx_xlsx/_api/contextinfo"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}" What we’ve already tried Replaced Web.Contents with the SharePoint connector in the query. Re‑authenticated the connection(s). Adjusted privacy levels for cloud connections in the workspace. Verified permissions on the SharePoint file/folder. Questions Has anyone seen this error (Microsoft.Data.Mashup.ErrorCode 10122 / DM_GWPipeline_Gateway_MashupDataAccessError) appear only in the Service while Desktop works fine? Why would the same file succeed in one report but fail in another when queries and authentication are identical? Thanks in advance for any pointers!
just 2 ways to determine environment in pbi?
hi AI says these are our only 2 ways of dynamically checking which environment (dev,qa,prod) our pbi report is running in so we can display that tidbit of info right on the report. i hate the idea of manually having to change something that is occurring in something that borders automation like a fabric pipeline. how can we pass such info to power query thru params? we've never even dealt with the challenge of passing sql and other conn info dynamically either.
