Analytics on Azure topics

Hi everyone!

Thinuka99 — Fri, 13 Mar 2026 17:34:04 GMT

Hi everyone! 👋

I’m new to this community and currently learning Azure Analytics. I’m really excited to be here and connect with people who have experience in this field.

I believe the discussions and knowledge shared by members here are very valuable, and I’m looking forward to learning from all of you. If you have any advice, resources, or tips for someone starting with Azure Analytics, I’d really appreciate it.

Happy to be part of this community! 😊

How can I get the Sign-In logs activated?

yayaAmir — Tue, 20 Jan 2026 06:22:01 GMT

Hi

How can I get the Sign-In logs activated? and can I use it to audit Power Bi & Dynamics 365 sign-in attempts?

Thank you in advance.

Azure Functions vs. Azure Container Apps Choosing Your Serverless Compute

JohnNaguib — Mon, 06 Oct 2025 14:09:02 GMT

As organizations continue to embrace cloud-native architectures, the demand for serverless computing has skyrocketed. Microsoft Azure offers multiple options for deploying applications without worrying about managing infrastructure. Two of the most popular choices are Azure Functions and Azure Container Apps.

While both enable developers to focus on code rather than servers, their use cases, scalability models, and operational models differ significantly. Let’s break down the key distinctions and help you choose the right tool for your next project.

https://dellenny.com/azure-functions-vs-azure-container-apps-choosing-your-serverless-compute/

Cost-effective alternatives to control table for processed files in Azure Synapse

JuanMahecha — Wed, 25 Jun 2025 13:48:15 GMT

Hello, good morning.In Azure Synapse Analytics, I want to have a control table for the files that have already been processed by the bronze or silver layers. For this, I wanted to create a dedicated pool, but I see that at the minimum performance level it charges 1.51 USD per hour (as I show in the image), so I wanted to know what other more economical alternatives I have, since I will need to do inserts and updates to this control table and with a serverless option this is not possible.

Should I ingest AADNonInteractiveUserSignInLogs from Entra ID to a LAW

CSI — Thu, 20 Mar 2025 07:13:41 GMT

As the title says, I am interested in expert opinions on whether I should include the AADNonInteractiveUserSignInLogs from Entra ID in a LAW, as this table dwarfs the SignInLogs in terms of the amount of data (by a factor of 8x) and therefore creates higher costs.

Secondly, I am curious if there are ways to reduce the amount of non-interactive SignInLogs that are generated in the first place.

Specify which Entra ID Sign-in logs are sent to Log Analytics Workspace

CSI — Fri, 14 Mar 2025 13:29:15 GMT

Hi, as the title says I am curious if its possible if I can limit which login logs are sent to a Log Analytics Workspace. We currently have a couple of service accounts in use that generate a high amount of traffic (an issue being worked on separately) and would like to exclude the logs from these specific users from being sent to LAW.

Data archiving of delta table in Azure Databricks

Brian_169 — Fri, 03 Jan 2025 09:40:40 GMT

Hi all,

Currently I am researching on data archiving for delta table data on Azure platform as there is data retention policy within the company.

I have studied the documentation from Databricks official (https://docs.databricks.com/en/optimizations/archive-delta.html) which is about archival support in Databricks. It said "If you enable this setting without having lifecycle policies set for your cloud object storage, Databricks still ignores files based on this specified threshold, but no data is archived."

Therefore, I am thinking how to configure the lifecycle policy in azure storage account. I have read the documentation on Microsoft official (https://learn.microsoft.com/en-us/azure/storage/blobs/lifecycle-management-overview)

Let say the delta table data are stored in "test-container/sales" and there are lots of "part-xxxx.snappy.parquet" data file stored in that folder. Should I simply specify "tierToArchive", "daysAfterCreationGreaterThan: 1825", "prefixMatch: ["test-container/sales"]?

However, I am worried that will this archive mechanism impact on normal delta table operation?

Besides, I am worried that what if the parquet data file moved to archive tier contains both data created before 5 years and after 5 years, it is possible? Will it by chance move data earlier to archive tier before 5 years?

Highly appreciate if someone could help me out with the questions above. Thanks in advance.

Analytic Rules for Log Forwarder

Lumka1122 — Thu, 12 Dec 2024 06:43:57 GMT

Good day,

May you kindly assist with KQL queries to create these 4 analytic on our environment.

Log Rate-Insufficient

Agent Heartbeat Latency

Agent Heartbeat Monitor

Agent-Health-Alert

azure VM process monitor

RajkumarRamasamy — Tue, 26 Nov 2024 13:22:48 GMT

Will it be possible to ingress the data about the process with respect to file activity, command line used on that process from the windows VM, as like as the Process Monitor data.

Hd 10 tablet and thank get

triebeheh — Mon, 18 Nov 2024 07:46:53 GMT

HD the same thing a chance to you get me

How are you able to prepare for Azure certification or any other exams with full time job.

Nithin_khanna — Sat, 16 Nov 2024 11:48:28 GMT

I am 29 M and i had been working in cloud since 4 years now , i have worked on azure mostly but i guess now its time for me to look for another jobs in another organization as my salary has been constant since a long time. I feel like getting certified will give more opportunity and better probability of getting my resume shortlisted. Please share any hacks or tips if you have

Azure Log Analytics workspace

veerakumare22 — Wed, 06 Nov 2024 20:40:17 GMT

Hi All,
I have a requirement to keep log analytics workspace in standalone mode. i want o remove or break the communication between Azure resources with the log analytics workspace and keep it in standalone mode to protect the logs which are collected before. i want to keep those logs for an interval of 1 Year. is there any possible way to achieve this requirement. Please suggest.

Note:- This workspace is integrated with Sentinel as well.

Azure Data Factory Question

ayaansk99 — Sat, 19 Oct 2024 13:51:42 GMT

Azure Data Factory Question

Hi, I want to extract data from an API, and I'm confused about which activity in ADF I should use. Should I go with COPY or WEB activity?

Can anyone please help?

Understanding Data Ingestion for Log Analytics and Sentinel Workspace

ram512 — Fri, 11 Oct 2024 17:28:33 GMT

I'm trying to understand how data ingestion works for both Log Analytics and Microsoft Sentinel. Every time we notice a spike in data ingestion costs for Log Analytics, we see a similar increase in Sentinel costs as well. It seems like data is being ingested into both workspaces, potentially doubling the ingestion and driving up our costs.

Can someone explain if this is expected behavior, or if there's a way to optimize and avoid duplicate data ingestion between Log Analytics and Sentinel?

Understanding Data Ingestion for Log Analytics and Sentinel Workspace

Deleted — Fri, 11 Oct 2024 17:13:09 GMT

Can someone explain if this is expected behavior, or if there's a way to optimize and avoid duplicate data ingestion between Log Analytics and Sentinel?

Power BI Failing with the following error -

lohitdacha — Fri, 27 Sep 2024 17:38:49 GMT

Microsoft SQL: Cannot bulk load because the file "https://rbssynapselinkstorage.dfs.core.windows.net/000000611.json" could not be opened.

Integrate logic apps rules engine with Microsoft fabric

kc_analytics — Fri, 27 Sep 2024 08:28:16 GMT

Hi, I have a requirement where I need to integrate logic apps rules engine with fabric data pipelines.

When I run an ETL pipeline, it has to pick up the business logic from rules engine and transform the data in fabric data pipeline. Is this achievable? Need suggestions please?

Charged for Synapse Analytics SQL Storage

eduardoazzolin — Sun, 01 Sep 2024 01:49:48 GMT

Hi, everyone. I paused a dedicated SQL pool in Azure, and the charges for the pool stopped, but I'm still being charged for Synapse Analytics SQL Storage. How can I stop this? Do I need to delete the pool?

Azure Data Factory Multiple Copy Activity problem with pgSql

L1F19BSSE0033 — Wed, 14 Aug 2024 06:31:04 GMT

Hello,

I have been trying to copy multiple tables from a PostgreSQL database out of Azure using the copy activity and pasting the data in azure PostgreSQL.

It's like I have two copy activities for copying data into two tables but it is giving me this error

Operation on target Copy data1 failed: 'Type=Npgsql.PostgresException,Message=XX000: Tenant or user not found,Source=Npgsql,

Anybody who can guide me on this?

Your guidance in this matter will be highly appreciated.

Use Azure Screenshot for my thesis

marius1106 — Mon, 15 Jul 2024 09:31:40 GMT

Dear Microsoft Team,

In my bachelor's thesis, I plan to implement a BI process and would like to use screenshots from the development environments of Microsoft Fabric, Azure Data Factory, Azure Data Lake Storage Gen2, Azure Synapse Analytics, and PowerBI. Therefore, I would like to ask if I am allowed to use these types of screenshots in my thesis free of charge.

Best regards