New SharePoint Options to be aware of

SharePoint Embedded

We have all used SharePoint and the API's but this is really useful as it allows me to have full SharePoint API access to use with my applications.  So it can be protected and scale.  I've had tons of projects that should have used this but instead backed on dedicated Site Collections.

External user on SPO have to be guests, and you use the subscription model, so i think you can have 5 guests for each O365 paid user.  Issue is this is then giving access to your internal SharePoint/collaboration area.  SharePoint Embedded provides a dedicated area and offers two types of consumption/billing models: 

• ISV-led, and
• and direct-to-customer billing.

SharePoint Premium

SharePoint Premium offers advanced features such as AI/copilot...

Power BI Licencing Explained

 Power BI Licencing (Simple Overview)

(Simplified April 2024)

Power BI Free is for individual users who need to create personal reports and dashboards.  Perfect for people that don't need to share and want to analyse data in the business.

Power BI Pro is for individuals that need to share content, collaborate with others, and use all Power BI service features.  Circ $10/user/month.  People building reports and can share amonst other users with the Power BI Pro licence.

Power BI Premium is for large organizations with extensive data needs and a large number of users, including those who do not require full Power BI Pro capabilities.  All the content viewers of the reports and dashboards, don't need any licences.  Circe from $5k per month.  Perfect for 1 user creates a report and multiple users use the report.

Low code CoE thoughts

Key areas to address for a Low Code CoE:

1. Portfolio of Products
2. People/Skills/Experts
3. Process/ALM
4. Platform/Governance/Cleanup/Architecture/NFR's (scalability, SLAs)
5. Promotion/delivery/training

Consider putting the project through a Business case validation, particularly for larger projects.  The business case is how your business visualises and communicates a proposed project, which should continuously be refined.  Points to cover:

1. Business Case (Idea)
2. Customer Segment >
3. Value Proposition (what do they get) > 
4. Channels (API, website, AI Services, .. ) Customer Achievement (get and retain) >
5. Revenue (how to make money)
6. Key Resources (patches, maintenance) covers technology and data.  What tech, people need to build and continue delivering.  Data: where does it come from, quality, restrictions, relevancy.
7. Partners (dependency e.g. AWS, Azure, Mendix, OutSystems, UiPath, Microsoft, and backup options)
8. Cost breakdown

CoE needs to clearly understand its boundaries and responsibilities.  

I am a big fan of Total Ownership, clear requirements and goals, using RACI, and stand-ups. For the rest, I try to be agile and malleable. Big projects require more oversight and planning, so I allow teams to change and focus on delivery.  

My First Mendix Widget - Azure AI component to convert Text to audio

 https://www.youtube.com/watch?v=0bxJeYSDV28 (3min video)

Mendix Marketplace - Azure AI Services - Convert Text to Audio  - Here is is in the Marketplace.  Thanks to Ameer for helping me build the widget.

Basics to setting up an AI Transformation Program - High level

Overview: Many large organisations have begun their Artificial Intelligence (AI) journeys, but some have taken unusual directions, while others are adopting a wait-and-see approach.  As a general rule, I believe most organisations should attempt to identify the most important use cases for AI and, using a basic scoring system, prioritise the easy, high-value use cases first. 

A good option is to hire an AI-focused team to implement the AI program within your business.  Hire people from the company, as they possess key domain knowledge, and pair them with IT experts, preferably those with strong AI skills.  

Tip: All Digital Transformation Projects must cover People, Process and Technology in that order of importance.

Thought: The two biggest mistakes I have observed as of July 2025 in clients are a lack of clearly defined benefits of AI projects and poor-quality, insecure data.

1. AI Idea Generation: Collate a detailed list of possible ideas.  I like to use SharePoint, it's a good idea to open ideas up to the business or make gamification of idea generation to get a good set of ideas.  You'll get lots of overlap, distil it into unique ideas, and bring the team/stakeholders together.

Figure 1. AI idea filter funnel

2. Business Impact: How does this help our customers or generate revenue, or does this improve our operations?  Can this be quantified?

3. Technological Feasibility: Can technology meet the requirement, and at what cost?  A high-level technical design is strongly recommended, as illustrated in Figure 2 below.

4. Implement: If the idea holds up to Business impact, and is possible, select the highest value to lowest effort ideas.  It is a good idea to start with the simpler ideas to get the ball rolling.

Figure 2. HLD example

Note:  This post is looking at building AI to improve your business. AI also affects all internal staff, so train them.  Allow them to use AI tools like ChatGPT, and train them not to expose internal proprietary information.  Give your users the correct tools to be the most effective.

AI Digitalisation Transformation Checklist:

1. Data Governance Framework: Do you know what data you have, can you access it, and is it secure?
2. Enterprise Data Model: Define the rules for quality and integration between the EDM areas (these may be functional or geographic), ensuring we share data and make it available.
3. Master Data Management: Ensure the data and applications are working off the same sheet of music.  
4. AI Framework: What are the limitations on what you can do within business governance? How will you identify projects and prioritise them? How do you ensure alignment with the tools?  AI is expensive; don't just start picking our individual solutions.  I'd also call this 'measure twice, cut once.'
5. Don't eat the whole Elephant: Pick small projects to start with, clearly defined goals that show the wins from AI.
6. One Process: When the AI solution/project is built, will you still use the old way? It's expensive to create, document, and support multiple processes over the lifetime of solutions that have duplicate steps to accomplish the same task. Make your process simple and the preferred or only approach.
7. People: Have they checked the process? Is it optimised and not merely converted from the old paper process to digital?  Have you engaged key stakeholders and experts?  We should have asked if this is the best process, but also verified it with non-technical stakeholders.
8. Cost Optimisation and Value Realisation: AI-based transformations like Software development or engineering projects are about whole-life cost and value, ensure you are not just looking at building something.
9. Measurements and KPI's: How do we measure value? Are you monitoring usage and costs? They tend to be the easier measurements.  Security is also essential to measure, as well as what constitutes success.  Many benefits are intangible, so list them out. Can a value be guesstimated for intangibles?

I'm sure there are plenty more items, but this would be a good check to run repeatedly.

Low code ROI/TCO and observability - Monitoring Low code Platforms

Overview: With Low code gaining tremendous traction, the rate at which apps are being built is increasing quickly.   More citizens can build and pro developers can build more.

Governance helps maintain the quality of the apps and their code, but as an app needs to be updated, it becomes significantly expensive to maintain and update the low code solutions.  The P-F curve has been around for awhile for regular assets (I first saw this 20 years ago with Mining equipment in Southern Africa, Machine maintenance on the mines help significantly reduce the cost of the assets/equipment and reduce catastrophic outages, anyway I've digressed...).  

Microsoft Low Code/Power Platform:

All low-code platforms have the same issues, governance improves the situation but it does not address the P-F interval, and monitoring comes into play.  Microsoft's Canvas Apps has the ability to ship logs to Azure Monitor (App Insights) and there are internal analytics available on the platform.  These are great and should be implemented.  Now most enterprises have multiple environments and tenants in Power Platform, ALM is used to improve the quality of the application being  released.

Canvas apps has an internal testing tool called Test Studio which is fairly limited and yet still underused.  Tests can be recorded, on deployment releases the recorded rules can be run and reported on in ADO or any CI/CD pipeline.  

You can also make web calls from CI/CD or a dedicated service to continually run advanced availability tests, you should do this.  It ensure we pick up when part or all of the process changes.  And you can setup alerts and respond.

Tools:

You can also log to SIEM (enterprise logging tools) and use this for Monitoring.  For instance, you can ship you App Insights/Log Analytics/Azure Monitor logs to Dynatrace so it is part of your overall monitoring and response strategy.

You can continuously monitor API using CI/CD tools like ADO but I prefer to use Postman's Enterprise Infrastructure service (it's awesome).  Similarity, I am a full convert to Microsoft Playwright (I was a Selenium and Cypress fan, not i'm only Playwright).

Grafana, Power BI, Azure Dashboards all have different pros and cones for monitoring.  There is also some great AI stuff coming out at the moment around UI testing.  Specifically, I've seen Dynatrace, Playwright and BrowserStack use AI to compare screenshots for test validation.

I'll be expanding on automation, continuous testing in this series of posts.  These are my initial thoughts and there is a lot of good results coming out.

Unique solution to reduce licencing costs for Power Apps for Guest users when using SharePoint for storage

I have a fairly unique situation where I have a user base of a company employees using a Canvas App to work with SharePoint list data. This data is used to generate word documents. This 4 minute video provides the overview of the setup i used: