The ask, rebuild a legacy VB.NET desktop application as a Power Platform solution. The app was written maybe 17 years ago, hasn't been updated, and is a media tracker app, like a personal IMDb. Because it was a personal solution, not an enterprise solution, its data was stored in a Microsoft Access database, so this … Continue reading Solution Rebuild: Part #1 | Database – Access to Dataverse (Extracting + Transforming)
Microsoft Dataverse
Microsoft Dataverse: Table Designs w/ Copilot
The ask, create new Dataverse tables for an upcoming initiative. There are several existing tables that could be used for this initiative, but the project requirements necessitated new tables be created. Because this is an upcoming initiative, business stakeholders aren't ready to build the solution UI, even though Microsoft Copilot could create everything for them: … Continue reading Microsoft Dataverse: Table Designs w/ Copilot
Microsoft Dataverse: Virtual Tables [ Pros ]
Unfortunately, Microsoft Dataverse isn't a data storage consideration for many Power Platform makers because their organizations are already using other data sources like SQL Server, Salesforce, SharePoint Online (SPO), etc. These other data sources are well-supported, but Dataverse is the foundation of the Power Platform, so there is native integration for it in Power BI, … Continue reading Microsoft Dataverse: Virtual Tables [ Pros ]
Power Query: Overview
The capabilities of the Power Platform wowed many organizations. Especially Power BI and its ability to extract, transform, and load (ETL) datasets from dozens of disparate data sources. At the same time, Microsoft Dataverse, the low-code data storage offering of the Power Platform, also supports ETL of disparate data sources. Though, this isn't unique to … Continue reading Power Query: Overview
Power Platform: Data Sources | SQL Tables or Dataverse Tables
The Power Platform is Microsoft's collective of no-code/ low-code solutions. To supplement this platform, Dataverse is Microsoft's secure, no-code/ low-code data storage solution. SQL Server is still a strong contender for data storage, but leveraging it requires some mastery of SQL. Dataverse, however, stores data in tables just like SQL, but doesn't require any proficiency … Continue reading Power Platform: Data Sources | SQL Tables or Dataverse Tables
console.log('Charles'); 