-
SharePoint as a Corporate Data Warehouse: Pros and Cons
The current Corporate environment is continuously evolving. Organisations, whether small or enterprise, have their presence globally. Gone are the days where employees used to work from one dedicated seat in an office, now they work remotely. Firms are under tremendous pressure to be productive. Employees should be able to collaborate easily and meet deadlines, not
-
Exciting New Partnership and Innovative SharePoint Tools from AxioWorks and Lightning Tools
AxioWorks is excited to announce a strategic partnership with Lightning Tools, a leader in creating innovative SharePoint components. This collaboration is a pivotal moment in our dedication to enhance user experience with cutting-edge solutions. The partnership introduces a suite of tools ingeniously crafted to complement SQList, our flagship product for SharePoint to SQL Server synchronisation.
-
7 Reasons why SQL Server tables are a better option for reporting than SharePoint Lists
Need to generate reports on data stored in SharePoint Lists? Find out how SQList helps overcome the limitations of SharePoint data querying.
-
SharePoint Online List vs SQL Server as Data Source in Power-BI
Lists are primarily used as a source of data storage in the world of SharePoint and in most scenarios these lists can grow really fast especially if we are dealing with transactional data or a large store of reference data. As the SharePoint List grows and eventually goes over 5000 items, it becomes what we
-
Why use SQList to generate Power BI reports from SharePoint Lists, rather than using the Power BI native connector to SharePoint?
The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it on lists with many thousands of items and/or want to run queries across many large lists, you soon hit limitations in terms of amount of data you can query and the
-
Why Support Legacy SharePoint Versions Like SharePoint 2010?
In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why continue supporting legacy SharePoint versions like SharePoint 2010?” The answer, while seemingly straightforward, encapsulates a broader understanding of the technological landscape and the diverse needs of organisations. First and foremost, it is crucial to
-
Why Companies are choosing SQList over Power Automate
In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as significant players. Companies are always on the lookout for the most efficient tools, and this comparison elucidates why many are gravitating towards AxioWorks SQList over Power Automate. Sync Features Automatic Creation & Mapping: AxioWorks SQList stands
-
Why Choose SQList for SharePoint Data Extraction Over DIY Solutions
In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can code my own solution or use a no-code alternative for extracting #SharePoint data?” It’s a fair question, and in this article, we’ll explore the benefits of choosing #SQList over the DIY
-
The Collaborative Pathway: Bridging Minds in the AI Ecosystem
by Francesco Marcolini | AxioWorks CEO, Software Architect and Developer/// In recent days, I found myself immersed in an enlightening conversation with a friend, a fellow entrepreneur steering his ship in the vast sea of Artificial Intelligence (AI) just like myself. As we delved into the nuances of our individual projects, a revelation dawned upon
-
Use Graph API in Power Automate to read large Excel files from SharePoint
Power Automate, a part of Microsoft’s suite of tools, is increasingly becoming a preferred choice for automating workflows and business processes across a variety of platforms and services. It provides a rich set of features and connectors to help businesses automate their operations with minimal coding. One such common operation is reading Excel files from
AxioWorks