It took me some time to grasp the correct syntax for utilizing an XML format file in a BULK INSERT operation from Azure Blob Storage,… Read More »How to use XML Format File with BULK INSERT from Azure Blob Storage
Regarding my previous post: https://powerplatform.fi/how-to-read-a-csv-file-from-sharepoint-to-azure-sql-with-power-automate/ I got a question about how to read a JSON (not csv!) from Azure Blob Storage to Azure SQL. And yes, this… Read More »How to read JSON file from Blob Storage to Azure SQL?
CSV files are a common source of data for reporting purposes, and are usually delivered as email attachments or appearing in SharePoint, etc. Power Automate… Read More »How to read a CSV file from SharePoint to Azure SQL with Power Automate?
In Power Automate, you are handling quite often data in a JSON format which data can come from various sources, Dataverse, APIs etc. Instead of… Read More »How to insert JSON from Power Automate to Azure SQL?
I’m quite often getting a request to check the data quality on CRM environments. You can use SQL Server Management Studio to write select statements to… Read More »How to find duplicate accounts with SQL?
I was building integration and was required to create an XML file as end result. I found out that you are able to generate XML… Read More »How to create XML from SQL select query?