Our Blog
Microsoft Lists: The Evolution of SharePoint Lists
SharePoint Lists has played a pivotal role in building customised solutions on top of SharePoint making SharePoint not just a CRM or DMs but a development platform for developing solutions delivering a wide range of business scenarios. Every SharePoint developer/end-user have used lists in one way or another whether it’s just for creating announcements/tasks or…
Power BI Master/Detail Report from live SharePoint data
In the real-world, reporting often includes master/detail scenario in which a master list item is selected in order to get more details about the entity. In SharePoint, master data will be stored in a list that contains a lookup column of detail list/s, and getting data from multiple lists would require multiple data sources and…
New version of SQList released (6.2.0.0)
A new version of SQList: version 6.2.0.0 is out today! We haven’t blogged about new releases for years, why we don’t know. We’ve been notifying all our users of SQList, been publishing support articles, but not a mention on our website. Silly strategy you may think…and so do we! But it has not been a…
Use Google Data Studio with SharePoint data
In this blog, we will go through essential steps on how to generate a report and chart in Google Data Studio using data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to replicate…
Access live SharePoint data from SQL Server
In this blog, We will take an in-depth look into how SQList transforms SharePoint lists into SQL tables and how it stores data into each column. We will also look at how all changes made in SharePoint are continuously synchronized into their corresponding SQL Server tables.
Generate Excel Charts and Reports from live SharePoint list data
In this blog, I will show you the best way of creating a chart in Ms Excel on live data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to synchronize data between SharePoint…
Generate SSRS Charts and Reports from live SharePoint list data
In this blog, I will show you the best way of creating a chart in SSRS Report Builder on live data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to synchronize data between…
Generate Power BI Charts and Reports from live SharePoint list data
In this blog, I will show you the best way of creating a Power BI chart on live data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to synchronize data between SharePoint Lists…
Come and visit us at SharePoint Saturday in Leicester
We are proud to be one of the Gold sponsors of SharePoint Saturday in Leicester on Saturday, November 16, 2019. Why not come to our stand and meet us? We’ll be happy to give you a demo of SQList and discuss how it could fit into your organisation. We will also be giving a presentation…
The best way to access SharePoint data from Power BI, SSRS, and other BI tools
Watch our presentation, where we are going to show you the best way to access live SharePoint data from any reporting and BI tool, like Power BI, SSRS, or Crystal Reports.