The ask? Load the extracted and transformed Microsoft Access data into Microsoft Dataverse. But before performing the actual import, ask the important questions, "Could the data model be improved?" During the transform process, "Were there any column types that could be changed?" Often enough, while auditing the data, it may come to light that a … Continue reading Solution Rebuild: Part #2 | Database – Access to Dataverse (Loading)
Data Integrity
SharePoint Lists: Migrating to Dataverse Tables | Enforce Unique Values
The ask, help a maker scale their Power Apps solution. They created a canvas app some years back and being frugal, they chose SharePoint Online (SPO) lists as their app's data source. Now, three years later, that frugal decision is haunting them as they've hit the 2,000-item delegable limit. To rebuild their data source with … Continue reading SharePoint Lists: Migrating to Dataverse Tables | Enforce Unique Values
Data Governance: Reframed for Better Participation
The ask, propose some ideas for improved data governance. However, before jumping in and tackling governance itself, let's ask Copilot for a more high-level definition: With Copilot's definition in mind, is there an underlying organizational resistance to data governance? Generally, no. Everyone understands its importance and agrees that it could be improved upon. Rather, there's … Continue reading Data Governance: Reframed for Better Participation
Microsoft 365 Copilot: Data Readiness | SharePoint Online
The ask, evaluate and audit the SharePoint Online (SPO) environment before the Microsoft 365 Copilot rollout, Microsoft's artificial intelligence (AI) assistant for the M365 apps. The top-most concern of the business leaders is whether or not their content is permissioned properly. Though, a security audit could easily help identify SPO sites with lax sharing and/ … Continue reading Microsoft 365 Copilot: Data Readiness | SharePoint Online
console.log('Charles'); 