How to optimize real-time Power BI dashboard through Azure
Hi, I have a Power BI dashboard that displays real-time API traffic data which is working well so far. The Concern is, as the data is stored in an SQL database and connected to BI directly and as database grows, the querying and display times are getting…
How to send the history of 3 months of files from one directory to another according to the date in its name
Hello, I'm having problems because I want to move the history of some files stored in a data lake according to the date in its name, but in the end what I manage to do is only move either one specific day or all of them. example: I have files October -…
hii want to run stored procedure in synapse but ima getting an error ,can anyone help me
query: USE gold_db GO CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100) AS BEGIN DECLARE @statement VARCHAR(MAX) SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+' AS SELECT * FROM OPENROWSET(BULK…
Azure Data Lake Gen2 Disaster Recovery/Storage account failover Capabilities?
I am trying to wrap my brain around Azure Data Lake Gen 2 DR/Storage account failover capabilities and I feel as though I am getting conflicting information. On the Microsoft Documentation -…
remove chars from integer columns in databricks delta
Hi Expert, how to remove chars from column in databricks delta when datatype is not null col1 1 2 3 er ge e
Load files in appending in databricks
Hi Expert, I have 2 files in blob storage . file1.csv, file2.csv how will i load it in a view using appending order using *.csv extension using temp view file_list = dbutils.fs.ls("/mnt/mount/test/file")
jdfc url of blob storage
Hi , i wanted to push the files to blob storgate using portman ... how to connect using jdbc connection i tried below but unable to push it.. can i get jdbc file for…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Datalake account_partitioned table row count is verly low
We have azure datalake with builtin pool In that we have builtin account_Partitioned table which use to have similar no or rows as per non partitioned table but now from today only showing 10% of total rows We are in UK West region and something…
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
Correction on Microsoft PL-300 Practice Assessment Questions
This is to bring to the notice of the Admin in charge of Practice Test Questions under Pl-300 Power Bi Exam. There is a confusion in one of the questions and answers. Please find attached snap shot and correct the answers Thank you
![](https://techprofile.blob.core.windows.net/images/Z1PCM1zxm0SLa41PVP7B7g.png?8DA865)
Data lake zones and containers, what is the best practices of file name
Hi All, follow up Best practices from cloud Adoption framework, can somebody tell standers for file Name Data LakeLayersContainer numberContainer nameFile Name Standard1Raw1Landing?1Raw2Conformance?2Enriched1Standardized?2Curated2Data…
Can we pass partition key as a parameter in a generic/dynamic azure dataflow.
Operation on target Load Entity failed: Operation on target Load Entity failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: com.microsoft.dataflow.Issues: DF-TX-114 - Key partitioning does…
Help me decide between Azure data lake analytics and Azure Databricks
Both Azure Data Lake Analytics and Azure Databricks can be used for batch processing. Can you help me understand for which case we can use each one?
RowsWritten from data flow in log analytics
I was recently able to get the rowsCopied and rowsRead from a pipeline copy activity in log analytics....I'm trying to get the rowsWritten from the pipeline dataflow activity but I'm not getting any input. Is this even logged in log analytics? and if…
ADF converts NUMBER datatype to Decimal, String (if precision > 28) while copying data type from ORACLE to ADLS as Parquet
While extracting data from Oracle on premise to Azure Data Lake as Parquet files via SHIR, we notice the below points: NUMBER Datatype in Oracle gets converted to Decimal, String (if precision > 28) in parquet file Kindly share some light on the…
![](https://techprofile.blob.core.windows.net/images/5kfUQwbXfkqnY7o5wQqfdA.png?8DAA55)
Azure Data Lake Analytics Retirement - Frequently Asked Questions
On 29 February 2024, we will retire Azure Data Lake Analytics and this service will no longer be available. Before that date, please migrate your services that were deployed using Azure Data Lake Analytics to another Azure data processing product of…
How to backup ADLS for ZRS
Hi Experts, ADLS doesny support backup out of box. I want to backup the adls files for ZRS (zone level redudancy). Can anyone please suggest what is the best way?
sql query on blob storage
Hi Expert, how to write sql query on azure blob storage files using databricks notebook without using azure synapse
![](https://techprofile.blob.core.windows.net/images/VfQFAmOikEWfBHko2XlWTA.png?8D7F33)
How to fix api-version error when submitting jobs by using the Azure CLI?
I wanted to submit jobs by using the Azure CLI, but I found that "az dla job submit" and other "az dla" command lines cannot run successfully, an error was reported: api-version '2016-11-01' is invalid. Valid api-version:…
cluster performance in ideal time
Hi Expert, how to avoid the ideal time/sleeping time scenarios on databricks cluster so that it would run smoothly even though there is no traffic. and we should not start all the time and should run continuously
Data Transfer in real time between on-prem and cloud
Hello, i basically need my on-prem MS SQL db to be synced with cloud MS SQL DB at all times. As of now, i am thinking of using Azure Data factory but i fear it cannot perform near realtime data transfer. Other option is not use kafka to move data, but…