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
Creating integrations with Logic Apps (or Power Automate) and using the File System action through a gateway to your own server can get really tricky… Read More »How to overcome the 20 MB file size limit with File System action? (Error RequestEntityTooLarge)
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?