ADLS data incoporation with other data source
Hi friends, we have an ERP data in ADLS and we have come up with KPIs on that dataset, but business want KPIs that consist of ERP and legacy application data which has data since that legacy database host data since 1985 hence it want KPIs that enlist…
Azure Data Lake Storage
Upgrade to a storage account with Azure Data Lake Gen2 capabilities is temporarily disabled
Hi, I would like to upgrade a Storage Account with Data Lake Gen2 capabilities (hierarchical namespace). When I'm trying to do it from Azure console UI, I'm getting the message: "Upgrade to a storage account with Azure Data Lake Gen2 capabilities is…
Azure Data Lake Storage
ADLS structure approach
Hi friends, we are getting data from API endpoint , and saving the data in Parquet file format, since it is Parquet file format ,I have designed Data Lake hierarchical order in the form ,ADLS hierarchy for landing zone,bronze, silver layer now, for…
Azure Data Lake Storage
How to change Blob Inventory files daily generation time
In my Azure Data Lake Storage Gen2 storage account, I have a Blob Inventory rule to generate files daily: I want the files to be generated at the end of the day (9PM), since I have another scheduled process that consumes the generated data at 10PM every…
Azure Data Lake Storage
[URGENT] Accidental Deletion of Azure Data Lake Storage Gen2 Account – Can Data Be Restored?
Hello Microsoft Support Team, I am reaching out regarding an accidental deletion of our Azure Data Lake Storage Gen2 account. The storage account was deployed inside the Resource Group rg-x-production, which I unintentionally deleted. After the deletion,…
Azure Data Lake Storage
Exporting D365 F&O Data Directly to Azure Data Lake Gen2 Without Dataverse. Questions on Current Approach, Format & Folder Structure
Hi Everyone, I’m currently working on exporting all tables/entities from Dynamics 365 Finance and Operations (Tier 2 environment) directly to Azure Data Lake Gen2. I don’t want to use Dataverse in between. I’ve already created a Storage Account in Azure…
Azure Data Lake Storage

Azure Storage account tier availability
Hi, We plan on using Lifecycle policies in Azure Storage Account (ADLS). I know there are different SLAs for tiers. The question is: if a blob is in cold tier and this tier is unavailable, can we move it to hot tier and the blob can be read again? Would…
Azure Data Lake Storage
how to get SLA% of a storage account
we knew there a metric Availability showing the SLA% of a storage account (https://learn.microsoft.com/en-us/azure/azure-monitor/reference/supported-metrics/microsoft-storage-storageaccounts-metrics#category-transaction ), but this metric also contains…
Azure Data Lake Storage
Connecting to Azure Data Lake Storage Gen2 from Tableau Desktop is throwing error
Error Receiving in Tableau Desktop: Tableau received an OAuth error from your request. Please see the error message for more information: User authorization failed (invalid_client). When checked the auth url it seems the url is the one like below -…
Azure Data Lake Storage
401 Unauthorized "Audience validation failed" from ADLS endpoint
We are using service principal credentials to authenticate using OAuth2 token. Fetching the access token step is successful however, request getting failed when hitting ADLS endpoint . Error response : Exact error message :…
Azure Data Lake Storage
How to enable Managed Identity for accessing an ADLS Gen2 storage?.
How to enable or use Managed Identity for an ADLS Gen2 storage, instead of using storage access keys.
Azure Data Lake Storage
Transactional Data Vs Non Transactional Data : Partition Depth
Please can I have some perspective on storing Transactional Data in ADLS Gen2. I have read that we should store in Day wise partitions although the write operation could be slow but read operation could be faster. We have set of T and NT tables whose…
Azure Data Lake Storage

How to form Delta lake tables on top of Parquet files stored in ADLS GEN 2
Hi, Good day! I'm looking for some guidance on how do I create Delta Lake tables on top of Parquet files stored in ADLS Gen2. The constraint here is we don't have Databricks whitelisted by our organization policies. The ultimate goal is to perform CDC…
Azure Data Lake Storage

Does synapse serverless sql pool OPENROWSET support "parquest based structured stream" format?
I can read from a data lake structured stream using synapse serverless sql pool OPENROWSET, by specifying FORMAT = 'SSTREAM'. Does OPENROWSET support "parquest based structured stream" format? If yes, then what value should I specify to FORMAT…
Azure Data Lake Storage
Azure Synapse Analytics
Service Principle cannot access ADLS
Could you help me debug Service Principle has been granted a Storage Blob Data Contributor on the storage account level. However, it cant access the container, 403 Request ID: 9f415b7e-601f-0018-16f1-eb704e000000
Azure Data Lake Storage

Dropped sftp file upload
A file was uploaded to our blob storage via sftp by one of our vendors. Even though it showed the fle was sent it never made it to the xmlfiles container.See logs below. What could have been the cause? weekly inventory valuation Report for 06/28/2025…
Azure Data Lake Storage


Storage Approach Comparison in Azure ADLS Gen2
Hello, May someone please help me with valuable suggestion which approach I should Take. It would be great if share thoughts with Pros and Cons. Scenario 1 : Scenerio 2 : Scenerio 1 Details: 1.Silver layer stored in Azure SQL / Cosmos…
Azure Data Lake Storage
GDPR Handling In ADLS Gen2
I am creating a Centralised Data LAKEHOUSE as shown in Diagram. I have created a Second ADLS Gen2 so it easily connect with Databricks. I am seeking your valuable help in designing ADLS Gen 2 for silver layer. Do This approach is good. Do I need to…
Azure Data Lake Storage
Is it possible to create Lakehouse with case insensitive collation in Fabric?
Is it possible to make lakehouse SQL end point as case insensitive collation, Or is there way to create a lakehouse with case insensitive collation like we create warehouse (https://learn.microsoft.com/en-us/fabric/data-warehouse/collation)
Azure Data Lake Storage
Folder and contents within an ADLS blob deleted, no records within logs
Between the hours of 3:00 PM CST on 6/4/2025 and 8:20 AM CST on 6/5/2025, a folder and it's contents were deleted from one of our storage containers. This folder is not within our deleted items (we have 7 day retention enabled), and I cannot locate any…