dataflow
4646 TopicsScheduled refresh and Manual refresh Error
Hi i hope someone can help me to fix the issue regarding the refresh on my report, This report has been running for a year now suddenly 3 days ago errors keeps popping out. Thanks Data source error: DataSource.Error: OData: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. Microsoft.Data.Mashup.ValueError.DataSourceKind = Dynamics365BusinessCentral. DataSourcePath = Dynamics365BusinessCentral. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Cluster URI: Activity ID: Request ID: Time: 2026-10-09 16:30:35Z Details # Type Start End Duration Status Details 1 Data 10/10/2026, 12:15:21 AM 10/10/2026, 12:17:18 AM 1m 57s Failed (Show) 2 Data 10/10/2026, 12:18:18 AM 10/10/2026, 12:20:31 AM 2m 12s Failed (Show) 3 Data 10/10/2026, 12:22:31 AM 10/10/2026, 12:24:03 AM 1m 31s Failed (Show) 4 Data 10/10/2026, 12:29:03 AM 10/10/2026, 12:30:35 AM 1m 32s Failed (Show)133Views3likes9CommentsFabric trial extension
Why does my fabric trial never end? they keep extending it by 28 days when its close to expiry. i dont mind it, its good that i'm getting fabric capabilities for free. has anyone else faced this? is it because my account has PPU license? Just trying to underatnd the semantics behind this.65Views3likes3CommentsDataflow Gen2 Lakehouse connection fails with AADSTS70008
I am learning Microsoft Fabric and preparing for the DP-600 certification. I have spent several days trying to resolve a Dataflow Gen2 Lakehouse authentication failure, and I need help identifying the root cause. Environment Microsoft Fabric trial capacity, with a Fabric Free per-user license. Personal Azure Free account and a newly created Microsoft Entra tenant. Workspace: Nikolai_Schuler_Udemy. Lakehouse: LakeHouse_Training. Dataflow: Dataflow 1. Authentication: Organizational account, OAuth 2.0. Privacy level: Organizational. Gateway: None. The Entra tenant was originally created through an Azure signup using a personal Gmail account. I created an onmicrosoft.com member account with Global Administrator permissions and use that account for Fabric. The original Gmail identity exists in the tenant as a guest. Problem Dataflow Gen2 cannot connect to the Lakehouse. The query editor displays “Credentials are required to connect to the Lakehouse source.” When creating or updating the connection, Fabric reports: AADSTS70008: The provided authorization code or refresh token has expired due to inactivity. Send a new interactive authorization request for this user and resource. HTTP status: 400 Cluster: https://api.powerbi.com The same failure occurs when editing credentials for an existing connection. The account picker can open, but reauthentication has not restored access. A newly created connection appears in Manage Connections, yet the Dataflow editor still cannot connect. Troubleshooting completed Tested Chrome, Edge, and Edge InPrivate. Retried interactive sign-in using the onmicrosoft.com member account. Confirmed Microsoft Authenticator MFA is registered. Tested existing and newly created Lakehouse connections. Used Edit credentials in Manage Connections and Gateways. Confirmed the Lakehouse and SQL analytics endpoint are accessible in Fabric. Enabled GitHub integration and successfully synchronized the workspace to a public GitHub repository. This did not resolve the authentication error. Checked Entra sign-in logs. A previous Power BI Data Refresh sign-in failed with error 70008, and the credential update continues to fail with the same error. Support-access problem Microsoft's current support documentation says Fabric Free users can submit support tickets for Fabric products. However, the Fabric Help and Support form only offers “Add new contract”; “Microsoft Fabric Subscription” is missing. I submitted an Azure subscription-management request, but it was closed because Basic Support does not cover technical issues. I still have no technical support case. Questions Why does a fresh OAuth authorization continue to fail with AADSTS70008 in this new tenant? Is there a known issue with Dataflow Gen2, Power Query Online, or the Lakehouse connector's OAuth token handling? Could the tenant identity setup or Fabric trial capacity affect OAuth authorization or Fabric support eligibility? How can I obtain a proper Fabric technical support escalation as a Fabric Free user? Could a Microsoft Fabric employee or Data Factory specialist investigate this and advise on the next diagnostic step? I can provide the full trace ID, correlation ID, request ID, tenant details, and screenshots privately if needed.77Views0likes5CommentsI have to ask: does everyone have the same problems with Power BI as I do?
I've been working with ETL processes and notebooks in our Fabric environment. I replicate our Business Central environment to Fabric using BC2ADLS Open Mirroring, and I have a medallion structure (Bronze, Silver, Gold) that follows all the rules. Then I build semantic models on top of the Gold layer's fact and dimension tables. You'd think that once all this is set up, everything would just work. But something ALWAYS goes wrong every night when the data refresh runs. If it's not one thing, it's another: SQL endpoints that haven't refreshed, semantic models that can't read the data because certain tables weren't updated. This is driving me insane. Does everyone have these problems? Is this a full-time job just because this unstable setup never works the way it should? I don't have time to maintain this, it requires daily supervision. I find it extremely frustrating that Power BI has gotten so much attention, because it needs babysitting every single minute. I can see that this is a Gold mine for consultants, but it is a nightmare for a IT manager that wants to deliver reports to the business.Solved75Views0likes6Comments“Rule property no longer exists” (Alm_InvalidSetConfigRequest_InvalidRuleSet / NotFound)
Hi all, I’m trying to create a data source rule on a semantic model in the target stage of a deployment pipeline (new UI), and Save always fails with “Rule property no longer exists.” The docs only say to refresh the page and configure the rule again, which doesn’t help. I captured the actual request and response, so maybe this helps someone figure out what is going on. Setup Pipeline with three stages: Dev -> Prod -> a second Prod workspace. Import-mode semantic model with an incremental refresh policy, loading from a Fabric warehouse (SQL endpoint) through one shared Sql.Database(server, database) expression. No parameters control the connection, no DirectQuery. Dev and Prod warehouses have the same database name, only the server host differs. I’m the owner of the semantic model. “Data source rules” is enabled and “Parameter rules” is greyed out. Goal: rule on the Prod stage, From = Dev server / database, To = Prod server / database. What happens After picking From (the dialog lists the Dev server from the source stage) and To, Save returns HTTP 400. Request (trimmed): POST .../metadata/almpipelines/<id>/stages/1/configuration RulesData: [{ Selector: {“connectionDetails”:{“server”:”<dev-server>“,”database”:”wh_gold”},”datasourceType”:0}, CategoryName: “DataSourceRules”, NewValue: {Database: “wh_gold”, Server: “<prod-server>“} }] Response: {“error”:{“code”:”Alm_InvalidSetConfigRequest_InvalidRuleSet”,”pbi.error”:{“details”:[{“code”:”NotFound”,”detail”:{“value”:”{“artifactTypeName”:”Datasets”,”artifactId”:”<target model id>“,”ruleId”:”<rule id>“}”}}]}}} What I already tried The target model’s data source existed with that exact server and database (checked via the datasources API), both while the target still pointed at Prod and after I deployed the Dev definition once so it pointed at Dev. Same error. Rule deleted and recreated many times, page refreshed, fresh browser session. Checked there are no parameters, no table or column names with leading/trailing spaces (mentioned in older threads), and removed an unused second connection expression. No change. Questions What does NotFound for the rule mean here, and what is the rule validated against? Are data source rules supported for Fabric warehouse / SQL endpoint sources? The docs list SQL Server and Azure Synapse but not Fabric warehouse endpoints. Does it work with an incremental refresh policy on the model? Is there any supported way to create these rules (API or otherwise)? Right now I’m working around it by pointing every stage at the production warehouse, which means I can’t test warehouse changes in Dev through the model. I’ve seen similar unanswered threads going back years, so any hint on the root cause would be appreciated. Thanks!82Views0likes6CommentsPowerBIErrorCode: DatasourceAnalysisFailedWithUnknownFunctions
I'm currently working with PowerBI connected to MongoDB. I published the dashboard successfully. But the published dashboard is just empty and I'm getting the error. Please help me to resolve this error. Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: DatasourceAnalysisFailedWithUnknownFunctions Activity ID: 948d6f98-20b9-4abf-8d73-471bb21e7857 Correlation ID: 8566373e-e508-5062-2397-ffc5adf4f8aa Request ID: a5f465dd-b8b8-4683-b36d-26fcd98f2353 Time: Fri Oct 16 2026 12:03:34 GMT+0530 (India Standard Time) Service version: 13.0.28519.813 Client version: 2610.2.31321-train Cluster URI: https://wabi-us-north-central-h-primary-redirect.analysis.windows.net/63Views0likes4CommentsMissing Dataflow Gen1
Hello, I was creating several Dataflows on Power BI Service in the past. I just realized that I cannot create a new Dataflow Legacy/Gen1. When I am finding to create a new Dataflow, it shows only Gen2 and asks me to upgrade Fabtic trial. Is there any way I can create this, as I am not using Fabric capacity? Thank you for your help.Solved1.8KViews0likes5CommentsRight-sizing Fabric capacity with 11 models and 47 dataflows: where do you stop?
Hi all, I'd like to ask how you'd approach a Power BI and Fabric environment that has grown past what the capacity can comfortably handle, because I'm not sure we found the best way through it. The environment has been growing since 2021 and now has 11 complex semantic models (sales, production, job costing and finance) fed by 47 dataflows. Sources are an Odoo ERP hosted on AWS, Google Sheets and Google Drive, with ingestion through Power Automate. Over time the symptoms piled up: slow refreshes, heavy load on the server, and Fabric consumption that was higher than it should have been. On the governance side there were shared logins, weak role-based controls and unstructured workspaces. We started with an audit of every model, dataflow, governance setting and the Fabric usage. Then we consolidated fragmented models to cut redundancy, redesigned the dataflows, and moved to incremental refresh with query folding where possible. For governance we added RBAC, a Dev/Test/Prod workspace structure, sensitivity labels and lineage tracking, plus a certified semantic model and quarterly audits. After the optimization, we were able to bring capacity down from 64 CU to 16 CU, and in some cases 8 CU. What I'm curious about is how you decide where to stop. How do you know how far you can go on right-sizing before refresh windows or interactive queries start to suffer? Do you look at the Capacity Metrics app over a few weeks, or do you test by dropping the SKU and watching? And how much do you rely on smoothing and bursting? With 47 dataflows, would you keep them as dataflows, or move some of the heavier logic into a Lakehouse or Warehouse? And with sources like Google Sheets and an ERP, how do you confirm query folding is actually happening and not silently falling back? On model consolidation, did you go for fewer, bigger models or a central certified model with thin reports? What did that do to refresh times and to your DAX? Last one: for the Dev/Test/Prod setup, are you using deployment pipelines, or something else? Has anyone found a way to keep dataset and dataflow parameters from breaking between stages? Would love to hear how you've handled this.Solved70Views0likes7CommentsDataflow error connection Business Central Cloud
Anyone else seeing intermittent "Data source credentials are missing or invalid" errors with the Business Central connector in Power BI? Since 14th of October, we've seen Dataflows and semantic models using Dynamics365BusinessCentral fail to refresh, both in our own tenant and across several customer tenants. Nothing has changed on accounts, permissions or environments. What we're seeing: 🔹 Some tables in the same dataflow succeed while others fail in the same run 🔹 Failed tables error out after roughly 30 seconds, so it doesn't look like token expiry on long-running refreshes 🔹 Often the next scheduled refresh runs fine without any changes 🔹 Re-entering credentials helps on some dataflows, but not all We haven't found anything on the Fabric status page or Known Issues yet, and we have opened a case with Microsoft. If you're seeing the same, I'd love to hear about it, especially if you've found a workaround or have a Microsoft case or incident number. Thanks!472Views10likes18CommentsFabric Data Agent Access issue
I have created a fabric data agent using semantic model of a published report, It is working fine but I'm not able to share it with others I published the agent in M365 copilot and share with my teams of 100 people only 4 or 5 people can go to M365 copilot and search the agent and added the agent to their agent tab others are not even seeing the agent but if I share the agent link from M365 copilot then they see the agent but agent is not answering the questions but it's perfectly answering for me and other 4 to 5 people who see the agent when I surfed it said it said there are 2 level of access to get answer from the agent 1. agent level access 2. underlying data level access I have workspace contributor access for workspace, read, write, reshare permission for the agent. most of them share the same access but there are not able to see the only difference I found is I'm having premium per user license and most of other have pro license so I doubted it but internet says license is not an issue can anyone pls help me with this issue121Views0likes13Comments