Helping organisations get more value from the systems they already own. Understand, connect, and improve data, processes, and technology.
London, United Kingdom
Joined November 2019
- Tweets1.2K
- Following215
- Followers72
- Likes423
Is #SharePoint's flat architecture always better than sites and subsites?
Some thoughts based on my experience with #SharePointOnline and its underlying architecture. More a discussion point than a conclusion.
axioworks.com/2026/10/sharep…
#PowerBI refresh failing on lookup-heavy #SharePoint lists? Check the 12-join limit and when #SQList replication to #SQLServer is worth evaluating. axioworks.com/2026/10/power-…
New Support page: export #SharePoint document libraries to your file system with #SQList and #PowerShell.
See how: axioworks.com/support/export…
What does #Copilot in #SharePoint’s October update mean for site owners
Our guide covers new features, Copilot Credits, rollout timing and governance: axioworks.com/2026/10/copilo…
SharePoint report still stale after refresh? Trace the missing change through SQL and Power BI.
axioworks.com/2026/09/sharep…
#PowerBI #SharePoint
SharePoint permissions do not automatically become Power BI row
filters. New guide: how to design row-level security for Microsoft
Lists reporting with a governed SQL Server layer and hybrid options.
axioworks.com/2026/09/how-to…
#PowerBI #SharePoint #SQList
#MicrosoftLists are great for operational work, but reporting needn't depend on another cloud copy. This article shows a hybrid pattern: Lists as the front end, #SQLServer as the governed reporting layer, with #PowerBI or #MicrosoftFabric on top.
axioworks.com/2026/08/micros…
#PowerBI now makes #SharePoint Online embedding easier, but easier embedding does not remove the need for a SQL-backed reporting layer.
Why #SQList still matters for #SharePoint-to-#SQLServer synchronization and reliable reporting.
axioworks.com/2026/08/power-…
#PowerBI
#PowerBI #TMDL View improves semantic model governance. #SharePoint reporting still benefits from a #SQLServer layer.
New AxioWorks article on using #SQList to synchronize #SharePoint data for cleaner #PowerBI and #MicrofotFabric models:
axioworks.com/2026/08/power-…
#SharePoint list schema changes are normal. Broken #reporting does not have to be.
New #AxioWorks post: why synchronizing #SharePoint data into #SQLServer with #SQList helps keep #PowerBI and #MicrosoftFabric models stable as list
columns evolve.
axioworks.com/2026/07/sharep…
#PowerBI semantic models and #MicrosoftFabric apps need cleaner source data than #SharePoint lists usually provide directly. This new article explains the practical pattern: #SharePoint front end, #SQLServer
#reporting layer, and #SQList in the middle.
axioworks.com/2026/06/prepar…
#SharePoint and #MicrosoftLists are great for operations, but not ideal as a direct #reporting #database.
Why synchronizing that data into #SQLServer with #SQList still gives #PowerBI and #MicrosotFabric a stronger reporting
foundation in 2026.
axioworks.com/2026/06/sharep…
#MicrosoftLists is great for data capture, but not as a long-term #reporting #database.
New AxioWorks article: why #SQLServer is still the
right reporting layer for #PowerBI and #MicrosoftFabric - and where #SQList fits.
axioworks.com/2026/06/micros…
#OneLake shortcuts are great for #SharePoint/#OneDrive files.
For #SharePoint lists + metadata reporting, a #SQLServer layer still wins.
Pattern:
#SQList -> #SQLServer -> #PowerBI/#MicrosoftFabric.
axioworks.com/2026/05/micros…
#DataIntegration
Seeing #SharePoint + #PowerBI dashboards slow down as lists grow?
This article unpacks why that happens and how moving to a #SQL‑backed reporting architecture can fix it while keeping SharePoint for collaboration.
axioworks.com/2026/05/why-po…
#dataarchitecture #businessintelligence
Relying on Excel exports, Power Automate flows or custom scripts for #SharePoint reports?
Learn why these workarounds fail at scale and how a controlled #ETL path into #SQLServer delivers reliable #reporting:
axioworks.com/2026/04/common…
Large #SharePoint lists can work for collaboration, but not always for #analytics and #reporting.
Learn how list view thresholds, indexing and query patterns cause slowdowns, and when to move workloads to #SQL and #PowerBI‑ready stores.
axioworks.com/2026/04/why-sh…
Struggling to get dependable, near real‑time dashboards from SharePoint into Power BI?
Learn how a SQL‑first #dataarchitecture with views and incremental refresh turns list data into scalable #PowerBI reporting on #SQLServer with #SharePoint.
axioworks.com/2026/03/from-s…
Struggling with SharePoint dashboards that always need developer time?
Learn how to use embedded #PowerBI, #ExcelOnline and a #SQLServer reporting store to deliver fast, reliable #SharePoint visualisations without custom web parts.
axioworks.com/2026/03/visual…