Business Central v30: Power BI Dataflows using OData web services based on Microsoft pages
We currently have several Power BI Dataflows consuming Business Central data through OData V4 web services. Some of these web services are based on standard Microsoft Business Central pages. According to the Microsoft documentation, starting with Business Central v30 it will no longer be possible to expose a Microsoft page as an OData endpoint. We are currently on BC v29, so everything is still working, but this looks like potential technical debt that we should address before upgrading to v30. Many of these Dataflows are already in production and some retrieve accounting and operational data across multiple Business Central companies, so I would like to understand the recommended migration path rather than simply waiting for v30 to break the existing integrations. For those in a similar situation: Are you migrating these integrations to standard Business Central API pages/queries where available? For data that is not exposed through a standard API, are you creating custom API pages or API queries? Is replicating the existing Microsoft page in a custom extension and continuing to expose it through OData considered a reasonable transitional solution? Are there any relevant differences or limitations when consuming these alternatives from Power BI/Dataflows compared with the current OData page web services? I would be interested to hear how others are approaching this migration, particularly for existing Power BI solutions with multiple Dataflows and companies. Thanks in advance for any experiences or recommendations.
Models and reports in service
Hi, I have multiple reports in the same workspace, all connected to the same semantic model called ‘Model ABC’. None of the reports have their own semantic model. The issue: Older reports connected to this model show two download options when downloading: A copy of your report and data (.pbix) A copy of your report with live connection (.pbix) A newly published report connected to the same model shows only one download option: A copy of your report with live connection (.pbix) What I’ve checked: All reports point to the same semantic model None of the reports have their own model in the workspace Large Dataset Storage Format is ON for the semantic model The only difference is the older reports were published before Large Dataset Storage Format was turned ON My question: Why do older reports show two options and the new one doesn’t? How can I get the newly published report to also show two download options? Any help appreciated. Thanks.”
Gateway Stability Issues - v3000.338.2
Hi all, I've been having the problem with the Oracle connector not working from the June+ versions of the gateway. We attempted an update again yesterday using the October 2026 version which again caused the oracle connection to stop working again. We then tried the below fix I found suggested on the June release and it worked, oracle connection working again Go to C:\\Programa Files\\On-premises data gateway 2. edit the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config 3. update the following: <setting name=\"MashupFlight_DisableOracleBundledOdacProviderV2\" serializeAs=\"String\"> <value>False (change to True)</value> </setting> However shortly whilst doing some final testing I noticed that the gateway status was flipping back and forth between being online and offline every few seconds, though this eventually stopped after 20 minutes and was stable again. I did some testing to see if it impacted report refreshes using the gateway and they seemed to work fine. I've checked it again this morning and we'd had a handful of refresh failures for reports using the oracle connection on the gateway, and again it was doing the flipping back between online and offline. I manually refreshed the reports and they refreshed successfully and eventually after about 15 minutes the gateway stayed in online status. Has anyone else experienced this? I looked online for possible causes but none of them seemed to apply. I'm not sure if this problem is being caused by the fix that we did for the oracle connection of it's an issue with the October version of the gateway? Kind regards, David
Power BI Line Chart Conditional Formatting Works in Desktop but Not in Service
Hello everyone, I'm experiencing an issue with dynamic line chart colors in Power BI. My report displays the current and previous fiscal years. I'm using a DAX measure with conditional formatting to assign: Current Fiscal Year → Orange Previous Fiscal Year → Blue Everything works correctly in Power BI Desktop. However, after publishing to Power BI Service, both fiscal-year lines appear orange. Interestingly, the fiscal-year labels in the tables display the correct colors using the same DAX logic. I've also tried republishing the report, but the issue persists. Has anyone experienced this behavior? Is this a known Power BI Service rendering issue, and is there a workaround that preserves dynamic fiscal-year colors? Please find the attachment. Thank you!Power BI Dataflows failing with "You've reached the refresh limit for your account"
Since yesterday, several of our Power BI Dataflows have started failing with the following error: You've reached the refresh limit for your account. Please try again later. The failures occur almost immediately, sometimes in less than one second, so the refresh does not seem to actually start processing the data. Initially, I suspected this might be related to Dynamics 365 Business Central, as we upgraded from BC v28 to v29 yesterday and the Dataflow failures started around the same time. Some of the affected Dataflows use OData web services based on Business Central pages. We are aware of the upcoming changes/deprecation affecting this type of integration, but as far as I understand, this is expected with Business Central v30 rather than v29, so it should not be affecting us yet. More importantly, I have now tested a Dataflow using SharePoint as the data source and it fails with exactly the same error. This seems to indicate that the issue is not specific to Business Central, OData, or the recent BC v29 upgrade. We are using Power BI Pro/shared capacity, and multiple Dataflows are being affected. Has anyone experienced the same issue recently? Could this be related to a Power BI Service account-level refresh/concurrent evaluation limit or a current service-side issue?
Power BI subscriptions no longer include PNG attachments
Hello everyone, Since the recent changes to Power BI subscriptions, I no longer receive the report snapshot as a separate PNG attachment. The image is still displayed in the body of the email, but the PNG file itself is missing. Previously, the PNG attachment was very useful for our management reporting workflow. Is there any way to restore the PNG attachment, or has Microsoft permanently removed this functionality in the new subscription experience? Has anyone found a workaround? Thank you!
Snowflake: Different parameters in Power BI Desktop and Service after publishing for Warehouse
Hi everyone, we are using Power Query parameters for our Snowflake connection, including a parameter called SF_WARHOUSE. Our desired setup is: Power BI Desktop / local development: SF_WARHOUSE = DEV_WH Power BI Service: SF_WARHOUSE = POWERBI_WH The problem is that when a developer publishes/overwrites the report from Power BI Desktop, the parameter value from Desktop will be also be deployed to the PowerBI Service. We would like developers to permanently keep DEV_WH locally without having to remember to change the parameter to POWERBI_WH before every publish. We currently don't have Fabric/Premium Capacity, so Deployment Pipelines with deployment rules aren't an option for us. How do you handle this scenario? Is there a way to keep environment-specific parameter values in the Power BI Service when republishing from Desktop, or is it only possible over some kind of REST API / PowerShell automation (which might not be in real time)? Thanks!
Memory issue
Hello community I get this error on a table visual in the Power BI Service in a Table visual : The context is the following Table Source : ~600M rows, Import mode, loaded from Snowflake. Capacity: F64. The visual only uses columns from the table (no DAX, no calculated columns). The query is over the limit as you can see. Is there a way to stay under it while keeping a single visual? Can the per-query memory limit be raised on F64, or is 10 GB the maximum for this SKU? Thank you!New Ribbon - very odd
I'm not sure I want to support our users with the new ribbon, it's poorly designed, takes a whole extra line of screen-estate, and I really don't want to encourage people to embed in powerpoint. Simple things like revert filters has an icon with a refresh symbol rather than revert - any UI person knows the difference. Can I opt-out for all uers on our service?
