cicd
461 TopicsDataflow gen2 using variables from Variable Libraries Failing
I have a dataflow gen2 in a fabric workspace. I'm updating our workspace so it can be used with deployment pipelines. For this I'm parameterizing navigation queries and destination M code to read lakehouse and workspace ids from a variable library. I pull the variables into the dataflow using a seperate query per variable and I use the function Variable.ValueOrDefault(). Using this method I pull the lakehouse and the workspace id. I use these ids to both pull in tables from the lakehouse into the query, in addition to using them in the destination query for the final output of the gen2. In the preview the gen2 works fine and I am able to save it. When I run it I have encountered two different error messages: Unable to create a table on the Lakehouse SQL catalog due to metadata refresh failure, for Lakehouse Id: a underlying error Unable to create a table. I took over ownership of the lakehouse like the message reccomends but that hasn't solved the issue. I have also encountered this error: There was a problem refreshing the dataflow: "Source query: "sl_odoo_gl_transactions", Message: Expression.Error: The key didn't match any rows in the table.." In the above query sl_odoo_gl_transactions is the name of both the query of the final output table and the name of the table it is writing to in the lakehouse. Thank you for any assistance with this matter.Solved35Views0likes2CommentsHaving Error when connecting to data source
Hi all, I am getting this error when I try to use the Copy Data with the Dynamic AX connector to connect my D365fo data to the Lakehouse. I have setup the APP registration from Azure with my Microsoft Entra ID. Below is the error detail I get. Error code: 23205 Details: Requesting response from path and query failed with status code Forbidden and message {"Message":"Please verify that the user is valid and set up correctly."}.Solved31Views0likes2CommentsConcurrent Git Branching in Fabric Workarounds for Data Rehydration?
Hi Fabric Community, We're looking for recommendations on Git branching strategies for multi-developer teams in Fabric. The Challenge: In Synapse, developer branch selection was independent per user. In Fabric, changing the workspace Git branch alters the branch for all users in that workspace, making concurrent development on separate branches difficult. Current Workaround & Pain Point: Fabric documentation recommends creating a new workspace per feature branch. Issue: Rehydrating data for every feature workspace is time-consuming and something we want to avoid. Questions: What is the recommended best practice for isolated concurrent feature branching in Fabric? Are there established patterns (e.g., using shortcuts, thin reports, or shared lakehouses across dev workspaces) to avoid rehydrating data for each feature workspace? Appreciate any insights!32Views0likes3CommentsConcurrent Git Branching in Fabric Workarounds for Data Rehydration?
Hi Fabric Community, We're looking for recommendations on Git branching strategies for multi-developer teams in Fabric. The Challenge: In Synapse, developer branch selection was independent per user. In Fabric, changing the workspace Git branch alters the branch for all users in that workspace, making concurrent development on separate branches difficult. Current Workaround & Pain Point: Fabric documentation recommends creating a new workspace per feature branch. Issue: Rehydrating data for every feature workspace is time-consuming and something we want to avoid. Questions: What is the recommended best practice for isolated concurrent feature branching in Fabric? Are there established patterns (e.g., using shortcuts, thin reports, or shared lakehouses across dev workspaces) to avoid rehydrating data for each feature workspace? Appreciate any insights!50Views0likes5CommentsRayfin/Fabric Apps: support for mapping @entity() to a non-dbo SQL schema
Hello, We are developing a Microsoft Fabric App using Fabric Apps / Rayfin SDK version 1.33.1. We need to organize the physical SQL tables by application module using custom schemas, for example: - schema_1.table_1 - schema_2.table_1 However, the current Rayfin code-first generation appears to use the default dbo schema and generates unqualified table sources. We would like to confirm whether Rayfin supports mapping an @entity() to a table in a non-dbo schema. Is using a non-dbo SQL schema supported by Rayfin/Fabric Apps? If supported, what is the exact decorator, configuration, or rayfin.yml syntax? Regards,Solved96Views0likes5CommentsHow to deploy OrgApp and OrgAppAudience from one workspace to another workspace using GitHub Actions
Hi Team - I was looking to achieve the CI/CD for OrgApp and OrgAppAudience. I have a workspace-Dev which is Git Integrated and has the OrgApp and OrgAppAudience in below structure format. Sales Results.OrgApp ├── .platform ├── definition └── .children └── Sales Results.OrgAppAudience ├── .platform └── definition I'm trying with to achieve this deployment automation with GitHub actions. Steps performed are 1. Install fabric-cli 2. Login using Managed Identoty to fabric CLI 3. Deploy using fab deploy with config file with Items in scope as "OrgApp" and "OrgAppAudience" Observation Error - It looks the Fabcric CLI does not support this type of deployment. Please let me know the possibilities to achieve this deployment using GitHub actions only. FAQ on the Fabric User GroupsSolved166Views0likes11CommentsLearning migrating through Event-Driven Data Pipeline
Sharing my learning with the community and looking forward to your feedback and suggestions. Building an Event-Driven Data Pipeline in Microsoft Fabric Today I worked on a hands-on scenario to understand how a change in an ADLS Gen2 CSV file can automatically trigger data processing and load transformed data into a Fabric Warehouse. Complete Pipeline Flow ADLS Gen2 Storage ↓ CSV Created / Modified ↓ Azure Blob Storage Event ↓ Fabric Eventstream ↓ Event-Based Trigger ↓ Fabric Pipeline ↓ Copy Data ↓ Fabric Warehouse – Employee ↓ SQL / Dataflow Transformation ↓ GROUP BY EmployeeID, EmployeeName + SUM(Salary) ↓ Warehouse – emp_aggregated Key Learnings • Understanding event-driven pipeline execution in Microsoft Fabric • Using Azure Blob Storage events with ADLS Gen2 • Connecting storage events with Fabric Eventstream • Triggering a Fabric pipeline based on source file changes • Loading data into Fabric Warehouse using Copy Data • Applying transformations using SQL / Dataflow Gen2 • Creating aggregated business-ready tables • Exploring dynamic content and activity outputs for reusable pipelines This was a great hands-on exercise to understand how different Fabric components work together to build an automated data pipeline.Solved167Views0likes5CommentsWorkspace Git Sync Error - Unable to initialize your workspace
I currently cannot sync from git into our central DEV-workspace anymore. I have tryed syncing the git-branch into a different workspace and it works. When trying to sync the DEV-workspace, I instantly get an error "Unable to initialize your workspace". Syncing is not even tried. Please note that to fix a syncing error, we already detached and reattached the git-branch from the workspace.Solved111Views0likes4CommentsPrepping for DP-700 in ~18 days — what should I prioritize, and where?
I'm sitting the DP-700 exam in about two and a half weeks. I've already been through Aleksi Partanen's 11-hour video course and hold DP-600, so I have the Fabric fundamentals down — workspaces, OneLake, general security concepts, etc. I've also worked through the official Microsoft Learn paths for Ingest Data, Implement a Lakehouse, and Real-Time Intelligence, plus the official DP-700 study guide as my checklist. What I'm trying to figure out is where the real gaps are likely to be for someone in my position, and which resources are actually worth the time versus which ones just repeat what a DP-600 holder already knows. A few specific things I'd love input on: Which parts of the exam tend to catch DP-600 holders off guard — is it mostly the streaming/Real-Time Intelligence side, the monitoring and optimization domain, or something else entirely? For anyone who's taken it recently: were there topics that came up on the exam that aren't well covered by the official Learn paths above? Any specific resource — a course, blog, practice test, or lab — that made a real difference for you beyond the standard Learn paths? Happy to hear about paid resources too if they were worth it. Any recommendations on how much weight to put on hands-on PySpark/KQL practice versus reading — did the exam lean more toward code recognition or conceptual/scenario questions? Appreciate any pointers, especially from people who've taken it in the last month or two given the exam content gets refreshed periodically.156Views0likes5Comments[PBIUG Italy - RT] PBI Explorer Showcase
PBI Explorer lets you take full ownership of your Power BI reports It gives you a code-first view of your PBIX/PBIP reports. All visual properties, settings, and relationships are fully exposed in Tabular Editor style. It Explorer provides a git-like diff view between two reports, highlighting what's been modified or removed and it provides a view of all elements from the data model used in the report. You can see all report features that are difficult to inspect visually (like bookmarks, filters, etc). Mathias is one of the creators of PBI Explorer and he will guide us through it.305Views0likes0Comments