Our blog

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 time it takes to execute them. When you connect to a data source (e.g. a database, Excel file, or in this case SharePoint lists) from power BI you can choose two way of connecting to […]
[read article]

18 Oct 2021 | Share:

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 call a Large List. Large lists have their fair share of obstacles most of which can be dealt with using list views and indexing columns however when it comes to reporting on these lists […]
[read article]

15 Sep 2021 | Share:

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and beneficial for you. So, if you would like us to cover any specific SQList feature or if you want to learn more about any SharePoint feature then please do let us know. What has AxioWorks been up to? The focus of this past month has been growth – growing our customer and partner base, and connecting more with our existing clients. We have […]
[read article]

30 Aug 2021 | Share:

by Danish Ali Detho | O365 & Power Platform Solution Architect

In today’s world, data analytics has to become pivotal for making informed decisions and decision-makers are always keen to find new and innovative ways to improve their knowledge about their customers. One of the key facets of that information is the geographic of your customers especially when your customers are geographically scattered around the county or World. This allows organizations to know which regions are performing well and where do they need to focus more to improve their […]
[read article]

16 Aug 2021 | Share:

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and beneficial for you. So, if you would like us to cover any specific SQList feature or if you want to learn more about any SharePoint feature then please do let us know. What has AxioWorks been up to? The main focus of this month has been the SQList update planned to be released by the end of September 2021. In order to deliver the best possible […]
[read article]

01 Aug 2021 | Share:

by Danish Ali Detho | O365 & Power Platform Solution Architect

The World is moving towards virtual reality which is considered by most tech gurus as one of the technologies of the future. The capabilities offered by this somewhat magical technology are beyond the realm of the traditional way of how we perceive the designing of websites/pages as it will allow the site users to be fully immersed in the VR-enabled site pages. From an end-user perspective, this means rich interactions and capabilities which were not possible before, and from a website […]
[read article]

31 Jul 2021 | Share:

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and beneficial for you. So, if you would like us to cover any specific SQList feature or if you want to learn more about any SharePoint feature then please do let us know. What has AxioWorks been up to? After the successful release of SQList 7.0, the primary focus this month was to get some feedback on the new features and to finalize the feature […]
[read article]

03 Jul 2021 | Share:

We are looking for someone with experience in the SharePoint and BI arenas to take on the role of Sales and Marketing Manager. You will be able to work mostly independently on mutually agreed strategies. Your main responsibilities will be managing existing leads and generating new ones, with the final objective of increasing sales. Our company, AxioWorks, develops and sells SQList, an application that synchronises SharePoint lists and libraries to SQL Server tables. Thanks to this […]
[read article]

18 Jun 2021 | Share: