westerdale.blog https://westerdale.blog A SharePoint Consultant's Journey, On The Road to Collaboration Sun, 17 Dec 2023 17:00:58 +0000 en-GB hourly 1 https://wordpress.org/?v=6.9.1 https://westerdale.blog/wp-content/uploads/2021/03/cropped-small-logo-WSL-Favicon-2021v2@2x-1-32x32.png westerdale.blog https://westerdale.blog 32 32 Connect Power BI Desktop to Azure SQL Edge or SQL Server 2019 on Docker https://westerdale.blog/connect-power-bi-desktop-to-azure-sql-edge-on-docker/?utm_source=rss&utm_medium=rss&utm_campaign=connect-power-bi-desktop-to-azure-sql-edge-on-docker https://westerdale.blog/connect-power-bi-desktop-to-azure-sql-edge-on-docker/#respond Wed, 01 Nov 2023 19:56:17 +0000 https://westerdale.blog/?p=239476 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 testing TSQL scripts or creating visuals in Power BI. This post explains […]

The post Connect Power BI Desktop to Azure SQL Edge or SQL Server 2019 on Docker first appeared on westerdale.blog.

]]> https://westerdale.blog/connect-power-bi-desktop-to-azure-sql-edge-on-docker/feed/ 0 The Attempted operation is prohibited because it exceeds the SharePoint List View threshold https://westerdale.blog/attempted-operation-exceeds-sharepoint-list-view-threshold/?utm_source=rss&utm_medium=rss&utm_campaign=attempted-operation-exceeds-sharepoint-list-view-threshold https://westerdale.blog/attempted-operation-exceeds-sharepoint-list-view-threshold/#respond Wed, 12 Jul 2023 10:08:00 +0000 https://westerdale.blog/?p=235663 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. This saltatory lesson became apparent when a client asked me to troubleshoot […]

The post The Attempted operation is prohibited because it exceeds the SharePoint List View threshold first appeared on westerdale.blog.

]]> https://westerdale.blog/attempted-operation-exceeds-sharepoint-list-view-threshold/feed/ 0 Restart or re-enable your flows with PowerShell and Microsoft 365 CLI https://westerdale.blog/restart-or-re-enable-your-flows-with-powershell-and-microsoft-365-cli/?utm_source=rss&utm_medium=rss&utm_campaign=restart-or-re-enable-your-flows-with-powershell-and-microsoft-365-cli https://westerdale.blog/restart-or-re-enable-your-flows-with-powershell-and-microsoft-365-cli/#respond Thu, 24 Nov 2022 19:03:58 +0000 https://westerdale.blog/?p=235596 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 Cmdlets and the commands from the CLI for Microsoft 365. Restart Flow Runs […]

The post Restart or re-enable your flows with PowerShell and Microsoft 365 CLI first appeared on westerdale.blog.

]]> https://westerdale.blog/restart-or-re-enable-your-flows-with-powershell-and-microsoft-365-cli/feed/ 0 Use a JSON Formatter to view Power Automate Action Outputs. https://westerdale.blog/use-a-json-formater-to-view-power-automate-action-outputs/?utm_source=rss&utm_medium=rss&utm_campaign=use-a-json-formater-to-view-power-automate-action-outputs https://westerdale.blog/use-a-json-formater-to-view-power-automate-action-outputs/#respond Mon, 18 Oct 2021 13:05:18 +0000 https://westerdale.blog/?p=235478 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 the right hand Edge Chromium menu locate […]

The post Use a JSON Formatter to view Power Automate Action Outputs. first appeared on westerdale.blog.

]]> https://westerdale.blog/use-a-json-formater-to-view-power-automate-action-outputs/feed/ 0 Power Apps Survival Guide: Naming Standards https://westerdale.blog/power-apps-survival-guide-naming-standards/?utm_source=rss&utm_medium=rss&utm_campaign=power-apps-survival-guide-naming-standards https://westerdale.blog/power-apps-survival-guide-naming-standards/#respond Thu, 29 Apr 2021 19:58:05 +0000 https://westerdale.blog/?p=216772 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 can also incorporate more expressive styles when naming Screen controls […]

The post Power Apps Survival Guide: Naming Standards first appeared on westerdale.blog.

]]> https://westerdale.blog/power-apps-survival-guide-naming-standards/feed/ 0 Power APP: How to fix the BAD SOURCE Connector Exception https://westerdale.blog/power-app-how-to-fix-the-bad-source-connector-exception/?utm_source=rss&utm_medium=rss&utm_campaign=power-app-how-to-fix-the-bad-source-connector-exception https://westerdale.blog/power-app-how-to-fix-the-bad-source-connector-exception/#respond Sat, 23 Jan 2021 16:32:29 +0000 https://westerdale.blog/?p=207488 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 Connector . We noticed the issue after we sucessfully provisioned the […]

The post Power APP: How to fix the BAD SOURCE Connector Exception first appeared on westerdale.blog.

]]> https://westerdale.blog/power-app-how-to-fix-the-bad-source-connector-exception/feed/ 0 Set Up App-Only Access To Your Tenant to solve (401) Unathorized Errors https://westerdale.blog/set-up-app-only-access-to-your-tenant-to-solve-401-unathorized-errors/?utm_source=rss&utm_medium=rss&utm_campaign=set-up-app-only-access-to-your-tenant-to-solve-401-unathorized-errors https://westerdale.blog/set-up-app-only-access-to-your-tenant-to-solve-401-unathorized-errors/#respond Fri, 26 Jun 2020 16:28:18 +0000 https://westerdale.blog/?p=34434 Setting up an App-only principal in SharePoint Online is documented in Grant Access using SharePoint App-Only This post highlights how this approach can resolve: “Unauthorized (401) errors”, running tenant level PnPComandlets such as Set-PnPStorageEntity , under an global admin account with multi-factor authorisation (MFA) enforced. The remote server returned an error: 401 Unauthorized   Create […]

The post Set Up App-Only Access To Your Tenant to solve (401) Unathorized Errors first appeared on westerdale.blog.

]]> https://westerdale.blog/set-up-app-only-access-to-your-tenant-to-solve-401-unathorized-errors/feed/ 0 Enable MFA for Users with Office 365 E3 and E5 Licenses https://westerdale.blog/enable-mfa-for-users-with-office-365-e3-and-e5-licenses/?utm_source=rss&utm_medium=rss&utm_campaign=enable-mfa-for-users-with-office-365-e3-and-e5-licenses https://westerdale.blog/enable-mfa-for-users-with-office-365-e3-and-e5-licenses/#respond Mon, 08 Jun 2020 20:52:07 +0000 https://westerdale.blog/?p=34298 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 covers the options for enabling MFA for users with just Office 365 E3 […]

The post Enable MFA for Users with Office 365 E3 and E5 Licenses first appeared on westerdale.blog.

]]> https://westerdale.blog/enable-mfa-for-users-with-office-365-e3-and-e5-licenses/feed/ 0 Protected: GITHub Cheat sheet https://westerdale.blog/github-cheat-sheet/?utm_source=rss&utm_medium=rss&utm_campaign=github-cheat-sheet https://westerdale.blog/github-cheat-sheet/#respond Sun, 12 Jan 2020 09:49:22 +0000 https://westerdale.wpmudev.host/?p=1134 There is no excerpt because this is a protected post.

The post Protected: GITHub Cheat sheet first appeared on westerdale.blog.

]]> https://westerdale.blog/github-cheat-sheet/feed/ 0 Cycle Live Nottingham 2019: 75 Miles https://westerdale.blog/cycle-live-nottingham-2019-75-miles/?utm_source=rss&utm_medium=rss&utm_campaign=cycle-live-nottingham-2019-75-miles https://westerdale.blog/cycle-live-nottingham-2019-75-miles/#respond Sun, 30 Jun 2019 18:46:46 +0000 https://westerdale.wpmudev.host/?p=1101 [ngg src=”galleries” ids=”13″ display=”pro_blog_gallery”]

The post Cycle Live Nottingham 2019: 75 Miles first appeared on westerdale.blog.

]]> https://westerdale.blog/cycle-live-nottingham-2019-75-miles/feed/ 0