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.

Image for blog article Generate Power BI Charts from live MS Lists data

Generate Power BI Charts from live MS Lists data

In our previous article on MS Lists, we did a detailed introduction including some of the great features which can help any business in implementing use cases like issue tracking and inventory management. In this blog, we will use MS Lists to create an issue tracking solution using an out of the box template and then we will use SQList to synchronize data between MS Lists and SQL Server database. Finally, we will use Power BI to generate charts. AxioWorks SQList continuously export SharePoint […]
[read article]

08 Nov 2020 | Share: Twitter icon LinkedIn icon

Image for blog article 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

by Danish Ali Detho | O365 & Power Platform Solution Architect

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: Twitter icon LinkedIn icon

Image for blog article Create a Power Virtual Agent and integrate it with a SharePoint list

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

by Danish Ali Detho | O365 & Power Platform Solution Architect

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 […]
[read article]

30 Aug 2020 | Share: Twitter icon LinkedIn icon

Image for blog article 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: Twitter icon LinkedIn icon

Image for blog article 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: Twitter icon LinkedIn icon

Image for blog article 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: Twitter icon LinkedIn icon

Image for blog article 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: Twitter icon LinkedIn icon

Image for blog article 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: Twitter icon LinkedIn icon

Page 10 of 17 | Go to page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

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

*