Auto-Magic Data Ingestion in Lakehouse using Fabric Data Activator & Pipelines
Microsoft Fabric Hands-On Connect — An Interactive Knowledge Sharing Event The NextGen Data Aspirants Community (NDAC) is back with another power-packed, hands-on session — this time diving deep into real-time data automation using Microsoft Fabric. Whether you're a beginner exploring the platform or an enthusiast ready to automate your data flows, this session will show you how to harness the full power of Lakehouse, Pipelines, and Data Activator — all in one seamless flow! Date: 26th July 2025 Time: 06:00 PM IST Duration: 1 Hour 15 Minutes Session Abstract: Imagine this — you drop a CSV file into your Lakehouse and, like magic, it transforms into a Delta Table automatically. No manual intervention. No waiting. Just pure automation. In this interactive session, we’ll walk through a real-world end-to-end solution built inside Microsoft Fabric, where: -Fabric Workspaces are configured -Pipelines handle dynamic metadata-driven data flow -Data Activator monitors events in real-time -CSV files get ingested and converted to Delta Tables effortlessly Session Takeaways: -Fabric Workspace & Lakehouse setup essentials -Pipeline design using Get Metadata, ForEach, and Copy Data activities -Setting up real-time triggers with Data Activator -Automating Delta Table creation on file drop -Best practices and tips for production-ready ingestion Whether you're building your first pipeline or scaling your data workflows — this session will empower you to automate like a pro using Microsoft Fabric. Join us at WhatsApp: https://chat.whatsapp.com/GHBzZ7rKqylLyXTGJqyTxz Follow us at LinkedIn: NextGen Data Aspirants Community: Overview | LinkedIn Join us at teams: https://teams.live.com/l/community/FEAVIPJvr_9CQiYFgI Join us at Meetup: NextGen Data Aspirants Community | Meetup Let’s Explore, Learn, and Innovate — Together! Thank you!
Power Platform and Co-Pilot Agents
We’re excited to announce our next Arlington Microsoft Fabric User Group session! This month’s topic is Power Platform and Copilot Agents. May 21, 2026 8:00 PM CST Online This will be a beginner-friendly session focused on understanding how Power Platform, Power Automate, and Copilot Agents connect to enable automation and AI-powered workflows. Our speaker, Abil Varkichan Jose, will walk through the topic in a simple and practical way, making it a great session for anyone interested in getting started with automation, Power Platform, or AI agents. Join the meeting here: https://teams.microsoft.com/meet/246554003811755?p=KdAcgz0jW9SeAIvnMZ We’d love to have you join us and be part of the conversation! #MicrosoftFabric #PowerPlatform #PowerAutomate #CopilotAgents #AIAgents #DataCommunity #ArlingtonTX
Automated Dataflow to Logged-In Account
Hi all, I have an idea that could streamline the user experience in Power BI. When a user logs into their account, the data flow should automatically direct to the logged-in account. This would ensure that each user only sees data relevant to their own account, enhancing security and personalization. Currently, users may need to manually select their data source or filter the data after logging in. By automating this process, we can improve efficiency and reduce the risk of errors. Has anyone tried implementing something similar or know if this is possible with existing Power BI features? Any insights or suggestions would be greatly appreciated. Thanks for the help!
Power BI Report Server Dashboard Usage Stats
I'm interested in learning how to generate usage statistics, such as user logins, dashboard visit counts, and least-viewed screens. Could anyone please guide me through the process of creating an execution log or utilizing existing data to develop a Power BI report for publication on the Report Server web portal? Additionally, is it possible to automate the generation of these usage reports?PowerBI - CICD using Azure DevOps
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. Currently, there is no direct way of Implementing CICD in PowerBI. Using the Publish menu from the PowerBI Desktop is the easiest way to deploy/publish a report as of now. In this article, we are going to see how we can implement source control and CICD for PowerBI using Azure DevOps.
Invoice Checking for automation purposes
Hi PBI Community I want to create a DAX measure which returns a "✓" when the invoice amount posted is equal to the same as the previous journal entry posting. and a "✗" when the invoice amount is different. It needs to be conditional on the Amount being posted to the same G/L Account ID and the same Vendor Name. I made the following, but it doesn't consider the element of previous journal entry posting or whether it is the first posting for that Vendor and related G/L Account ID. Automation Check = if(ISBLANK([TY (EUR)]), blank(), IF(CALCULATE([TY (EUR)] / [€ Avg.]) = [# Postings], FORMAT("✓", "Green"), FORMAT("✗", "#Red") )) How could I change it so that the measure returns "x" when it is first postings as well, and not only compares total amount / avg. posting = count of postings. The matrix visualization looks like this right now:
Automated row for averages in Power Query
Hi there, so my question is that in power query is there a way for me to get a new column that shows the average of values in a row? The number of columns will be updated on a daily basis. So, would need the average column to be updated on a daily basis. For eg: We have a table here, say just 4 columns of data as of now and 5th column being average of 4 columns on a row wise representation. What if tomorrow, another column comes in between Jan 4 & average column. I need a way for it to automate this and give me row wise data whenever a new column is added. This image is just an example from normal excel, but my data is processed in Query, of course can't show the photo since data is sensitive. Once processed within Power query, I have it loaded into a Pivot table. So, it makes crucial for me to have data set in exact same format. what can be done?
