The most secure method for protecting your data in Synapse is through the use of Azure AD. To query data stored in the data lake through a Synapse Serverless endpoint, the AD...
It looks like the rights of the SQL Admin user in the database created by Synapse Link for Database have recently been changed. Prior to 2023, the SQL Admin user account has...
Once you have configured Synapse Link for Dataverse you are likely to want to give your data consumers access to read the Dataverse data from Synapse. This post covers how to...
Power Fx the low code macro language of the Power Platform is starting to become an omnipresent feature across the Power Platform family. The Nov 2022 Preview release of Power...
By default Synapse for Dataverse exports records as in-place updates so if the record already exists it gets updated and if not it gets created. This can be configured so that...
The preview of Power Fx formula columns in Dataverse has just been announced. Up until now, I ignored formula columns as they were only available in Dataverse for Teams. So I...
I previously wrote a couple of blog posts (post1 and post2) suggesting two different ways to access your Dataverse metadata in Synapse. Both of these techniques are now...
I previously did a post that demonstrated how you can use Power Automate Desktop to extract text from a PDF. At the time you were not able to extract tables from a PDF. In Feb...
Many organizations require that personal data in non-production Dataverse environments is anonymized. This may be company policy or a legal requirement such as GDPR which...