Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Our blog

AxioWork news, product updates, useful articles, hints and tips on how to make the most of your SharePoint data and Power BI Reports.

Power BI Master/Detail Report from live SharePoint data

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 then modelling their relationships in Power BI. In this blog, I will show you how easy it is to achieve a master-detail scenario on live data coming from SharePoint […]
[read article]

25 May 2020 | Share: Share on Twitter Share on LinkedIn

New version of SQList released (6.2.0.0)

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 strategy as much as a negligence on our part, and today we’re putting an end to it! AxioWorks SQList continuously export SharePoint lists and libraries as normalised […]
[read article]

30 Apr 2020 | Share: Share on Twitter Share on LinkedIn

Use Google Data Studio with SharePoint data

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 data from SharePoint Lists to SQL Server database which will later be used in Google Data Studio to generate a chart and to finish things off, we will look at how to display the report in SharePoint. Scenario Create […]
[read article]

22 Mar 2020 | Share: Share on Twitter Share on LinkedIn

Access live SharePoint data from SQL Server

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. Scenario Replication of SharePoint lists data into SQL Server database and analysis of the columns created in SQL table for the respective SharePoint list columns of various types, including choice, currency, single-lookup, […]
[read article]

29 Feb 2020 | Share: Share on Twitter Share on LinkedIn

Generate Excel Charts and Reports from live SharePoint list data

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 Lists and SQL Server database and to finish things off, we will look at how to generate our reports and charts much faster. Scenario Create a bar chart in Ms Excel which shows the total price and total current stock of […]
[read article]

28 Jan 2020 | Share: Share on Twitter Share on LinkedIn

Generate SSRS Charts and Reports from live SharePoint list data

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 SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate our reports and charts much faster. Scenario Create a column chart in SSRS Report Builder which shows the total price and […]
[read article]

06 Jan 2020 | Share: Share on Twitter Share on LinkedIn

Generate Power BI Charts and Reports from live SharePoint list data

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 and SQL Server database and to finish things off, we will look at how to generate our reports and charts much faster. Scenario Create a bar chart in Power BI showing the total price and total current stock of products […]
[read article]

18 Dec 2019 | Share: Share on Twitter Share on LinkedIn

Come and visit us at SharePoint Saturday in Leicester

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 on The best way to access SharePoint data from Power BI, SSRS, and other BI tools, where we will be demonstrating how we can easily create a Power BI chart on live data from SharePoint lists in minutes. And […]
[read article]

06 Nov 2019 | Share: Share on Twitter Share on LinkedIn

Page 4 of 10 | Go to page: 1 2 3 4 5 6 7 8 9 10

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*