• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Power Platform

Power Platform combines the power of PowerBI, PowerApps and Power Automate into one business application platform and is fully integrable with the Microsoft business suite. There are many advantages to using Microsoft Power Platform such as improved control over processes and broad systems integration. Check out all the latest Power Platform posts below from troubleshooting to creating custom applications.

Synapse – SQL Admin

24th January 2023 by Joe Gill

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 by Synapse Link for Dataverse. Now if you query a Dataverse external table using the SQL Admin account  you will get an error   "Cannot find the CREDENTIAL  … [Read more...] about Synapse – SQL Admin

Synapse Link for Dataverse Security

16th December 2022 by Joe Gill

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 data using an Azure AD group. Synapse supports both SQL and Azure AD authentication however Microsoft recommends using Azure AD credentials. … [Read more...] about Synapse Link for Dataverse Security

Power Fx -Power Virtual Agents

28th November 2022 by Joe Gill

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 Virtual Agents includes the ability to use Power Fx in the authoring canvas. The addition of Power Fx greatly enhances the ability to add capabilities like data validation and manipulation directly in … [Read more...] about Power Fx -Power Virtual Agents

Synapse Link for Dataverse – Append-Only

25th August 2022 by Joe Gill

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 record changes are appended as new records rather than updated. This can be done from the advanced options under Manage tables by selecting show advanced configuration settings and selecting the … [Read more...] about Synapse Link for Dataverse – Append-Only

Power Fx Formula Columns in Dataverse

22nd July 2022 by Joe Gill

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 with calculated fields and how they handle nulls. Strictly speaking, calculated fields handle nulls correctly and if you perform an arithmetic operation on a … [Read more...] about Power Fx Formula Columns in Dataverse

Next Page »

Primary Sidebar

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

Synapse Link for Dataverse Security

16th December 2022 By Joe Gill

Power Fx -Power Virtual Agents

28th November 2022 By Joe Gill

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

Synapse – SQL Admin

Synapse Link for Dataverse Security

Power Fx -Power Virtual Agents

Synapse Link for Dataverse – Append-Only

© 2023 · Joe Gill