-
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
-
From Punch Cards to Python: Still Hitting the Keys in my 50s
by Francesco Marcolini | AxioWorks CEO, Software Architect and Developer/// I spent the entire weekend writing code, not because of deadlines to meet or million-pound dreams, but for the kick that I still get from doing it. Especially now, with the wave of AI and all its amazing potentials unfolding before our eyes. It’s a
-
AI and Data: The Symbiosis of Interaction and Accuracy
by Francesco Marcolini | AxioWorks CEO, Software Architect and Developer/// Artificial Intelligence (AI) has rapidly emerged as a revolutionary technology that fundamentally alters the nature of human-machine interactions. By its design, AI is exceptionally proficient in directly engaging with humans, understanding their instructions, and providing contextual responses. However, it is important to note that the
-
Safeguarding Secrets with Secure Strings and Environment Variables in the Power Platform
In today’s interconnected digital landscape, safeguarding sensitive information and maintaining robust security measures is of paramount importance. The Power Platform, a suite of Microsoft tools, offers a powerful solution for developers and businesses to create customized applications, workflows, and automations. In this blog post, we will dive into the world of secure strings and environment
-
Case study: Document management in the Oil and Gas industry
In the realm of the Oil and Gas industry, efficient document management takes on a paramount role, particularly when it comes to auditing and compliance. With a multitude of regulations, contracts, safety protocols, and engineering plans, companies operating in this industry heavily rely on robust document management systems to ensure adherence to stringent standards. By
AxioWorks