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.

Use Power Apps AI Builder to extract data from invoices and store them in SharePoint

Use Power Apps AI Builder to extract data from invoices and store them in SharePoint

Introduction Organizations all over the world are trying to find new ways of automating their business processes in order to reduce redundancies, minimize manual data entry and human error. Artificial intelligence plays a significant role when it comes to improving the business process by taking automation to the next level where the process is not only automated but smart and self-sufficient as well. Microsoft Power Automate provides businesses the capability to automate their business […]
[read article]

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

Create a Power Virtual Agent and integrate it with a SharePoint list

Create a Power Virtual Agent and integrate it with a SharePoint list

Introduction Virtual agents and bots have become an essential part of customer support in every business. It provides the fastest way to provide the information a customer is looking for without waiting for a customer support agent or searching through a website. They can cover large no of use-case scenarios including providing product information, helping with flight/hotel bookings, or tracking orders. Today we will take a look at how easy it is to create a Power Virtual Agent and integrate it […]
[read article]

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

Microsoft Lists: The Evolution of SharePoint Lists

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 storing complex relational data for an application. But when it comes to list-based scenarios that include share, track and view […]
[read article]

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

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

Page 3 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

*