• Home
  • Blog
  • About Me
  • Home
  • Blog
  • About Me

Microsoft’s Power Platform  allows organizations to easily build and deploy low-code applications.

FEATURED

Dataverse  ·  Power Platform
Power Platform Analytics – SQL

If you have started to try out the Microsoft Power Platform self-service analytics you might have noticed some  inconsistences in the formatting of Json files it creates. Most of the files are created in ndjson format but a few resembled a...

Continue Reading


Datavseres Metadata - Azure Synapse
Azure  ·  Dataverse  ·  Power Platform  ·  SQL
Dataverse Metadata in Synapse

Note: the Dataverse metadata is now available out of the box and so this approach is no longer relevant. I have an updated post here When you configure Synapse Link for Dataverse it exports your Dataverse data into a Synapse...

Continue Reading


Dataverse  ·  Power Platform
Power Fx Formula Columns in Dataverse

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 wanted to check out a little bugbear of mine...

Continue Reading

Power Platform  ·  SQL  ·  Synapse Link for Dataverse
Synapse Link for Dataverse – Metadata

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 redundant as Microsoft announced in May 2022 that the Dataverse metadata is...

Continue Reading

extract table from pdf and write as csv file using Power Automate Desktop
Power Automate  ·  Power Platform
Extract Tables from a PDF using Power Automate Desktop

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 2022 Microsoft announced that they...

Continue Reading

Dataverse  ·  Power Platform
Power Platform Analytics – SQL

If you have started to try out the Microsoft Power Platform self-service analytics you might have noticed some  inconsistences in the formatting of Json files it creates. Most of the files are created in ndjson format but a few resembled a...

Continue Reading

Power Platform
Dataverse Region

When you create a Dataverse environment it prompts you to select the region where you want it created. This is the datacenter region and the url of your environment indicates the datacenter regions where it is located e.g. crm4.dynamics.com indicates...

Continue Reading

Power Platform  ·  Power Virtual Agents
Power Virtual Agents – OTP

You can configure user authentication in your Power Virtual Agent bot to restrict access to resources using using Azure AD or OAuth2. A simpler approach for user authentication is to create an OTP, one-time password, send it to the user...

Continue Reading