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.

Announcing SQList v5.4

Announcing SQList v5.4

We are proud to announce a new release of SQList which provides even greater flexibility when exposing your SharePoint lists and libraries as a set of normalised SQL Server Tables. Version 5.4 of SQList is a minor update from ver. 5.x.x, you can, therefore, upgrade for free if you have a licensed version 5.x.  There are no breaking changes in this update. There are some great new features in our SQList 5.4 release, namely:  Support for SQL Server Temporal Tables SQL Server 2017 introduces […]
[read article]

12 Jul 2017 | Share: Share on Twitter Share on LinkedIn

Highlights of the SharePoint Summit – Live Report

Highlights of the SharePoint Summit – Live Report

Highlights of the Microsoft SharePoint Summit 2017 Microsoft unveiled plans for SharePoint, Onedrive and Offiec365 during the SharePoint Virtual Summit today (May 16th) Here’s a summary of some of the announcements and reaction to those [View the story “Highlights of the SharePoint Summit” on Storify] […]
[read article]

16 May 2017 | Share: Share on Twitter Share on LinkedIn

How To: Import SharePoint libraries into Power BI and create links to the documents

How To: Import SharePoint libraries into Power BI and create links to the documents

How To: Import SharePoint libraries into Power BI and create links to the documents If you have tried to import from SharePoint to power BI you have probably realised you can import Lists and folders but not libraries. In this post, which is based on a video by Ruth Pozuelo Martinez who is a microsoft MVP we’ll look at the Ruth’s suggested steps for doing the following: Export the data from a SharePoint document library into the Power BI desktop Create a visualisation that includes […]
[read article]

02 Apr 2017 | Share: Share on Twitter Share on LinkedIn

What’s new in SQList v5

What’s new in SQList v5

In this post I’m going to summarise all the updates to SQList in v5 releases (5.0, 5.1, 5.2, 5.3 and 5.4 at the time of writing) It’s probably worth saying that upgrades from v4 are available to all SQList customers who subscribe to our preventive maintenance plan. If you like more information about his or a would like a quote for an upgrade please contact our sales department. There have been a few potentially breaking changes in as part of the SQList v5 releases! Look out for […]
[read article]

01 Apr 2017 | Share: Share on Twitter Share on LinkedIn

5 Ways To Export SharePoint Data to SQL Server

5 Ways To Export SharePoint Data to SQL Server

5 Ways To Export SharePoint Data to SQL Server SharePoint provides us with a great way of capturing and managing data which has seen a huge increase in business data stored in SharePoint On Premise and SharePoint Online lists and libraries. This often means we have the requirement to report against this data. SharePoint doesn’t always make this easy for us! We can install reporting services into a SharePoint site but it’s still not easy to report against the data. As a consequence of the […]
[read article]

01 Apr 2017 | Share: Share on Twitter Share on LinkedIn

Announcing SQList v5.3

Announcing SQList v5.3

We are proud to announce the release of SQList v5.3. Today we announce some great new features in our SQList 5.3 release, namely: Export SharePoint lists that exceed the list view threshold Export attachments, without binary data Duplicate site configurations and database connections Configurable timeout for SharePoint web service connections Various bug fixes Let’s look at these changes in a bit more detail: Export SharePoint lists that exceed the list view threshold SharePoint limits […]
[read article]

28 Mar 2017 | Share: Share on Twitter Share on LinkedIn

Set up a scheduled export of SharePoint lists and libraries to SQL Server Tables

Set up a scheduled export of SharePoint lists and libraries to SQL Server Tables

Set up a scheduled export of SharePoint lists and libraries to SQL Server Tables In this article we will see how to: Schedule exports of SharePoint lists and libraries to normalised SQL Server database tables without any development effort Use the windows task scheduler and SQList to provide automated replications of complicated SharePoint data structures Get around SharePoint list threshold and lookup threshold issues Make SharePoint data available to SSRS, PowerBI, Tableau, SAP HANA and […]
[read article]

05 Mar 2017 | Share: Share on Twitter Share on LinkedIn

Announcing SQList v5.0

Announcing SQList v5.0

We are proud to announce the release of SQList v5.0. The following new features have been added to this release: Warning: There are a few potentially breaking changes in this release! Look out for this symbol  Archive SharePoint Data in SQL / Maintain deleted list items in SQL tables We have added a setting that enables you to maintain deleted list items in the replicated SQL table. This can be useful it you want archive SharePoint list items to SQL server.To disable the removal of deleted […]
[read article]

02 Oct 2016 | Share: Share on Twitter Share on LinkedIn

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

*