How to cancel disable azure subscription
I took student subscription on June and did some hands on practice after then I created dedicated sqlpool but forgot to delete. right now it shows 865$ that I need to pay so is there chance to get refund or cancel my subscription ?.
Access roles and Permission
Hi Team, We need to access synapse views from power bi and create dashboard reports. We have created AD group and provided SQL grant access to the AD groups. What else do we require so the power bi users can have least privileged access. Is it Synapse…
How to troubleshoot Azure Synapse Link failing to create/modify model.json
Hello, I am having issues with Azure Synapse Link failing to create or modify the model.json file in the blob. This only started happening yesterday. Can someone provide advice on what might be causing this issue and how to resolve it? Thank you. Best…
Trouble Granting Managed Identity Access for Pausing/Resuming Azure synpase
I’m fairly new to Azure and even though this might seem like a simple task, I’m finding it challenging. I’ve set up an Azure Synapse workspace with a dedicated SQL pool, and my assignment is to schedule pausing and resuming the pool. I followed a…
Unable to see all the lake database tables in synapse workspace
Hello, I am unable to see the Lake Database tables inside db blade on left side of synapse workspace, only few are visible but rest are not visible but I am able to see them through SSMS and also execute query on them. In fact, these tables are not…
adf/synapse - how to copy all files based on given lastmodified date from source container and save in sink container in respective folder based on extension
Req: Copy files from one container and store in another container- I am specifying the last modified date , i want to copy files only before that last last modified date. The files are of any type. csv,xml,json,txt etc. Also, in source container my files…
Notebook clusters in pipeline parallel processes
I have a pipeline triggered daily which loops through a list of notebooks, and runs them using a cluster in a for each run in parallel. At the moment I have seven notebooks running and adding more over time. What would happen when the cluster runs more…
How to configure use of access token and API key in a linked service
Authorization and x-api-key headers have been added to linked service for connection to C365 cloud service. Can't understand reason for error. Please help { "errorCode": "2200", "message": "Failure happened on 'Source'…
How to Set Up Automatic D365 Finance and Operations Data Replication to Azure Data Lake for Reporting?
Hi everyone, We have a D365 Finance and Operations environment hosted in the Central US region. Our Accounts Receivable (AR) data, including customers and invoices, is integrated from an on-premises Oracle database into D365 FinOps. I would like to…
Open row source
nsnapshot.txt Hi, how to run json file on synapse workspace.. Tried with open row set but not working.. Pls share screenshot if sny
How to query in synapse pipeline activity runs using api
Hi, How to query in synapse pipeline activity runs using api, i want to know inside pipeline how many activities we are running per day any option is there to find out this in synapse
Creating a pipeline to map data from Salesforce to Business Central using Azure Data Factory
Hi everyone, I’m working on creating a pipeline to map data from Salesforce to Business Central using Azure Data Factory. Here are the steps I’ve taken so far: Copy Data: I’m using the Copy Data activity to get the data into a CSV file. Azure Blob…
Can we execute Synapse Spark Notebook on synapse workspace from azure DevOps pipeline ?
Hi, I want to know Can I execute Synapse Spark Notebook on synapse workspace from the Azure DevOps pipeline ?
How to overwrite a table from SQL Server to SQL Dedicated Pool using Copy Data Activity in Azure Synapse Analytics
I am trying to use the Copy Data Activity in Azure Synapse Analytics to copy data from SQL Server to SQL Dedicated Pool. However, I want to ensure that every time I run the Copy Data Activity, the table in SQL Dedicated Pool is overwritten. How can I…
Stop and start Synapse pipeline triggers using pipeline
Hello, Is there a way to stop and start triggers using a Synapse Pipeline. I have tried with API mechanism like…
Fabric or ADF dataflows?
Hi I’m currently evaluating whether to use Fabric Data Flow or Azure Data Factory Data Flow for a specific data transformation project. In my scenario, I need to process and transform large volumes of sales data from multiple sources (including SQL…
How to make Log send to stderr and also shows in cell output
Hi Team, May I know in Synapse pyspark notebook, how can we write log to stderr, and also shows it in the cell output? I try to write the log with log4j, log will goes to stderr log, but will not shows in cell output But if we try with different log…
ADF Pipeline failing with an error saying column can be found
I have a pipeline that looks up a query to define the list of tables from source and usin for loop it should load data to Target Synapse pool but it is failing with following error on copy command.…
Job Queueing with Microsoft Fabric
Hi Team, We have a scenario where we need to move data from Oracle to One lake on demand. We are having a table where a user enters the configuration similar to batch and on each insert it needs to trigger the data movement pipelines .However I don't…
DATA_COMPRESSION = COLUMNSTORE_ARCHIVE not working for partitioned table
I created partition table(24 partition) with DISTRIBUTION = ROUND_ROBIN, CLUSTERED COLUMNSTORE INDEX . Table size was 300 GB but after DATA_COMPRESSION = COLUMNSTORE_ARCHIVE the size increased many folds(7-8 times).Does partitioned table archive is not…