-
SharePoint Power BI Report Not Updating After Refresh? Trace the Missing Change
If your SharePoint Power BI report is not updating after refresh, trace one changed item through the source, SQL reporting layer, semantic model and visual. A successful refresh confirms that an operation completed; it does not prove that the operation read the expected source or included the change you are looking for. This troubleshooting guide…
-
How to Apply Row-Level Security to Microsoft Lists Reporting in Power BI
Microsoft Lists and SharePoint lists are often where operational data starts. They are easy for business teams to manage, but they are not the same thing as a governed reporting security model. A common architecture question is this: how do you apply row-level security to Microsoft Lists reporting in Power BI without relying on SharePoint…
-
Modernisation Does Not Have to Mean Replacement
AI is changing technology quickly, but progress does not always begin by replacing what came before. A personal reflection on understanding existing systems before deciding what should change.
-
Microsoft Lists Reporting Without Another Cloud Copy: A Hybrid SQL Server Pattern for Governance and Power BI
Microsoft Lists and SharePoint lists are excellent operational tools. Teams can stand them up quickly, adapt columns as processes change, and keep day-to-day work inside Microsoft 365. The trouble starts when those same lists become important for governed reporting, audit retention, cross-system integration, or Power BI models that need to stay stable over time. A…
-
Power BI SharePoint Online Embedding in 2026: Why SQList Still Matters for SQL Server Reporting
Power BI’s July 2026 update made embedding reports in SharePoint Online easier. That is useful news for Microsoft 365 teams because it reduces friction when you want dashboards and operational reporting to appear where users already work. But easier embedding does not solve the harder problem underneath: where the SharePoint data should live before you…
-
Power BI TMDL View: Why SharePoint Reporting Still Needs a SQL Server Layer
Power BI’s July 2026 update brings TMDL View to the web, giving developers and data teams a code-oriented way to inspect and modify semantic model definitions without switching to Desktop or downloading model files. It is a useful step toward more disciplined analytics development. It also highlights a boundary that many SharePoint and Microsoft 365…
-
SharePoint List Schema Changes: Keeping SQL Server Reporting and Fabric Models Stable with SQList
Microsoft’s June 2026 Power BI update and July 2026 Microsoft Fabric updates both push teams toward richer semantic models, more governed analytics, and more AI-assisted data work. That is useful progress, but it also exposes a weak spot many Microsoft 365 teams still have: SharePoint list schema changes. When business teams add columns, rename fields,…
-
Preparing SharePoint List Data for Power BI Semantic Models and Fabric Apps with SQList
Microsoft’s June 2026 Power BI update put even more attention on semantic models, including Fabric Apps for Semantic Models in preview and more AI-assisted modelling workflows. At the same time, Microsoft Fabric keeps expanding governance, deployment, and SQL analytics capabilities. That is good news for analytics teams, but it also raises a practical architecture question:…
-
SharePoint to SQL Server Synchronization: The Smarter Microsoft Lists Reporting Pattern in 2026
Microsoft Lists keeps becoming a more important operational data source inside Microsoft 365, while the latest Power BI updates and Microsoft Fabric updates keep raising expectations for cleaner models, faster refreshes, and more reliable reporting. That combination creates a practical architecture question: if business teams continue to manage day-to-day data in SharePoint and Microsoft Lists,…
-
Microsoft Lists to SQL Server: The Reporting Architecture Power BI and Fabric Still Need (with SQList)
Microsoft Lists keeps getting more useful as part of the wider Microsoft 365 data experience. At the same time, the latest Power BI and Microsoft Fabric improvements keep raising expectations for faster modelling, cleaner semantic models, and more trustworthy reporting. That combination creates an important design question: where should your operational list data live when…
AxioWorks