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

Dataverse

Dataverse  ·  Power Platform  ·  SQL
Synapse – SQL Admin

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 able to query all the external tables created […]

Continue Reading
24th January 2023

Dataverse  ·  Power Platform
Synapse Link for Dataverse Security

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 provide users and service principals access to read your […]

Continue Reading
16th December 2022

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
22nd July 2022

Azure  ·  Dataverse  ·  Power Platform  ·  SQL
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
5th July 2022

Dataverse  ·  Power Platform
Dataverse Anonymization

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 governs the collection and processing of personal information in the European Union. Here is a […]

Continue Reading
25th April 2022

12
Page 1 of 2