Power Platform

LATEST UPDATES

Power Platform, SQL Server, Tools and Techniques

Connect Power BI Desktop to Azure SQL Edge or SQL Server 2019 on Docker

On a Windows 11 machine, I recently connected Power BI Desktop to both Azure SQL Edge and SQL Server 2019, hosted on Docker. By running these servers locally, you avoid connecting to the cloud and certain Azure hosting subscription charges, e.g. Pay-AS-You-Go, when...

Daniel Westerdale Nov 1, 2023 0

Power App, Power Platform, SharePoint

The Attempted operation is prohibited because it exceeds the SharePoint List View threshold

If you are building Canvas Apps with screens that browse SharePoint Online Lists containing over 5000 items; you should be mindful of how you configure these Lists and the impact on Filter, Search, LookUp , Sort ( single columns only) and SortByColumns functions....

Daniel Westerdale Jul 12, 2023 0

Power Platform

Restart or re-enable your flows with PowerShell and Microsoft 365 CLI

There are occasions, when you want to restart failed flow (Power Automate) runs or enabling (turning on) flows, after a solution deployment. You can do either of these tasks manually in the web browser or better still create repeatable scripts, combining PowerShell...

Daniel Westerdale Nov 24, 2022 0

Power Automate, Power Platform, Tools and Techniques

Use a JSON Formatter to view Power Automate Action Outputs.

Want a better way to view the output in a Power Atomate trigger action such as SharePoint: when an item is created and easily determine a property value? This post will show how you can have nicely formatted JSON output with a simple extension in Edge Chromium. In...

Daniel Westerdale Oct 18, 2021 0

Power App, Power Platform

Power Apps Survival Guide: Naming Standards

This post covers a suggested naming standard that will help to aid consistency and maintainablity when working on Power Apps. If you adopt the suggested three character prefix, you limit how much you need to type but still be able to distingish each control. You...

Daniel Westerdale Apr 29, 2021 0

Power App, Power Platform

Power APP: How to fix the BAD SOURCE Connector Exception

A short post covering how to resolve the {"Status": 400, "message":Bad Data Source.\r\n inner exception: Not a valid data source...} , should encouter this in a Power App connected to a backend SQL Server Express 2017 virtual machine (VM), using a shared SQL Server...

Daniel Westerdale Jan 23, 2021 0

Westerdale Solutions LTD

Make more of the Power platform

Design and deliver components of Power Platform solutions, focussing on:

Build both Canvas and Model-driven Power Apps though low-code development, to run in the browser on the desktop, tablets or mobile
With Standard, Premium or Custom connectors, integrate business data held in Excel, SQL Server, SharePoint, Dataverse hosted in the cloud or on-premises.
Replace manual processes with Power Automates to create an auditable history of actions, triggered by a schedule, e.g. end of month invoice creation or events such as MS Teams message or email
Power Pages for creating and hosting external-facing business web sites. Through starter site designs, rapidly build the sites that integrate data held in Dataverse, as well Power Bi, Power Apps and Power Automates
Creating Power BI reports to display charts, tables, maps and other visuals based on business data, accessed through a data set. Users can interact with the reports through filters, e.g. widget defects based on a manufacturer or geographic region

Contact Me

The Random Read

The blog post lottery, discover something new today with a random post from any category

Enable MFA for Users with Office 365 E3 and E5 Licenses

By Daniel Westerdale | 1 min read

It is a good idea to enable multi-factor authentication (MFA) for all users on your Office 365 tenant. The good news is there are a number of available versions of Azure multi-factor authentication depending on your requirements and available budget. This post...