Hello Reader,
Welcome to the December 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?
December has been a good month. In the first couple of weeks it was business as usual, busy, busy, busy. Then, in a matter of days, everything slowed down to a trickle; no customers requiring support, few daily emails in the inbox… at last, a well deserved break! So, how was this year?
2022 has been a busy year. With the Covid crisis behind us, we have worked hard to regain the momentum we lost in the previous two years. We’re not 100% back to pre-Covid levels yet but it’s getting there, and next year is looking good!
In terms of deliveries, we were able to deliver the regular maintenance and upgrades for SQList and we released SQList Online, the cloud version of our SQList, which is showing very promising signs. Customer support (a priority as always) took a good chunk of our resources and, based on the feedback we received, we must have done well.
This year we also expanded our Sales and Marketing team and got them up to speed, ready to start the next year running. They have already been in touch with some of you, and we must thank you for the very positive feedback you gave on SQList.
And the company growth does not end there, in 2023 we plan to expand our development team too and start working on yet another version of SQList as well as other projects.
We have great expectations for 2023 so keep watching this space! In the meantime,
HAPPY NEW YEAR from all of us at AxioWorks!
Focus blog entry: AxioWorks SQList is now available online
This year we launched SQList Online! The cloud-based software as a service (SaaS) version of SQList, our on-prem application that makes it extremely easy for organizations to store and synchronize SharePoint On-prem/SharePoint Online data into SQL Server databases, allowing them to efficiently generate reports using their preferred reporting tools like Power BI, Excel, or SSRS by connecting directly to SQL tables.
Read all about it: AxioWorks SQList is now available online.
SQList 30-second feature: Keep deleted SharePoint items in SQL Server with AxioWorks SQList
If you have very large SharePoint lists that have become difficult to manage due to their size, you may want to trim them but still have all data available to reporting tools or other LOB systems.
In this video you will see how you can use SQList to synchronise your SharePoint lists with SQL Server tables and keep deleted items in the table.
Click this link for a short video.
Featured articles
Here is a small selection of interesting articles from the net.
How to embed a Microsoft List form in a SharePoint page
If you are looking for a solution to increase the adoption of a new list in SharePoint or Microsoft Lists, getting it embedded in a new page might be a good approach. By embedding the new item form in a SharePoint page, users will be able to add data to list without leaving the page context, making the process faster and less disruptive.
Read more…
How Much Data Can You Load Into Power BI?
Power BI can handle large data volumes, but just how much data can you load into Power BI? Can Power BI handle big data? How big is “big” anyway?
Read more…
Enable SQL Server system versioning for SQL tables generated by SQList
In this article, we are going to see how to add SQL Server System Versioning to SQL tables created by SQList.
Read more…
That’s all folks, till next time.
Exporting SharePoint Data to SQL Server: The Best Way to Access SharePoint Data without Limitations
/in Uncategorized /by FrancescoSharePoint is a powerful collaboration and content management platform used by many organizations for storing and managing data. However, SharePoint has its limitations when it comes to data analysis and reporting, making it difficult to extract valuable insights from the data. This is where exporting SharePoint data to SQL Server comes in as the best way to access SharePoint data without any of the limitations of SharePoint. In this article, we will explore the benefits of exporting SharePoint data to SQL Server and how it can help organizations make better use of their data.
Read more
Microsoft 365 Copilot: AI Revolutionizing the way we work
/in Uncategorized /by Danish Dethoby Danish Ali Detho | O365 & Power Platform Solution Architect///
Artificial Intelligence (AI) is revolutionizing the way we do just about everything in life whether it’s doing chores at home or performing daily tasks in the office like searching for information, checking code for errors, or even creating original art. Microsoft’s Office tools have been setting the gold standard in productivity software, making Microsoft 365 a must-have for every business and now, AI is about to change how we use our favorite Microsoft 365 products, as well. In March 2023, Microsoft announced that they’re developing their very own answer to high-functioning chatbots like OpenAI’s ChatGPT called Microsoft 365 Copilot “your copilot for work”. In this blog, we will have a look at this new technology and how it is going to improve productivity in Microsoft 365 tools.
Read more
AxioWorks Newsletter March 2023: Focus on SQList next release
/in Uncategorized /by Danish DethoHello Reader,
Welcome to another exciting issue of our monthly Newsletter!
Each month, we try our best to bring 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?
AxioWorks team has made some major strives and is completely focused on getting SQList ver. 7.4 ready for production release. It will bring some new innovative features to improve the usability and adaptability of SQList.
Our content engineers continue to highlight what’s happening in the world of SharePoint, Power Platform, and MS365 through blogs and bi-monthly videos on O365/SharePoint/Power Platform so do subscribe to our YouTube channel and follow us on Twitter and LinkedIn. Read more
Our Favourite Picks from Power BI Global Summit 2023
/in Power BI, Uncategorized /by Danish Dethoby Danish Ali Detho | O365 & Power Platform Solution Architect///
Power BI Summit is the biggest Power BI conference of the year which ran virtually from 6th March to 10th March. It brought speakers from the Microsoft Power BI team’s product group, community experts, and MVPs from all around the world hosting more than 100 sessions at this conference. The conference has something for all levels from beginners to experts, Power BI Developers to Admins and Citizen developers with sessions covering a large number of topics including Power Query, DAX, Dataflow, Visualization, Power BI Desktop, Power BI report server, Mobile experience, Embedded, Power BI Premium, Architecture, and governance. In this blog, we will cover our favourite sessions from the Power BI Global Summit 2023.
Read more
AxioWorks Newsletter February 2023: Development of SQList new release is in full swing
/in Uncategorized /by Danish DethoHello Reader,
Welcome to another exciting issue of our monthly Newsletter!
Each month, we try our best to bring 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 development of SQList ver. 7.4 is in full swing and is scheduled to be released in April. For this release we are working on improving performance and including some of the most requested features. On a parallel track, we keep working on a major rewrite of some of the core components of SQList to allow connectivity to more data sources.
We are delighted to announce CSY Technical Services as an official reseller for SQList. We are actively seeking more resellers and sales partners to add to our portfolio so do reach out to us if you want to be a part of an exciting Sales Team with great commissions being offered.
The team has put together insightful content on some of the new features released by Microsoft in Power Platform and MS Lists in our bi-monthly videos on O365/SharePoint/Power Platform so do subscribe to our YouTube channel and follow us on Twitter and LinkedIn.
Focus blog entry: MS List Templates bundled with Power Automate Flow
MS Lists has become extremely easy to set up thanks to the List templates which let you create a list using a predefined template. Microsoft has made MS Lists even more powerful by adding built-in power automate flows to some of the List Templates covering some of the most common scenarios associated with the out-of-the-box scenario-driven templates.
Read all about it in this month’s article on List templates with bundled Workflows.
O365 feature of the month: Create new MS Lists using Flow-enabled Templates in MS Teams
MS List templates bundled with Power Automate Flows are so cool that we decided to do a vlog on it as well in which we will show you how this feature works, where the flows are stored in the Power Platform environment, and how to set them up while creating new Lists in MS Teams.
If you want to know more details about this feature, check out the video blog explaining how it works: Create MS List using flow-enabled Templates in MS Teams
Featured content
Here is a small selection of interesting articles/vlogs from the net.
How to create a video playlist for Stream Videos
Recently SharePoint lists and Microsoft Lists got a new playlist template that can be used to create playlists of Videos hosted in SharePoint that are reproduced in the new version of Microsoft Stream.
Read more…
How to integrate Chat GPT into the Power Platform
In this video, you will learn about how to easily integrate Chat GPT into Power Platform using Open AI.
Read more…
An Introduction To Power BI Dashboard
In this article, the author will discuss the basics of Power BI Desktop and demonstrate how to create a Power BI dashboard using Power BI Desktop.
Read more…
That’s all folks, till next time.
MS List Templates bundled with Power Automate Flow
/in Microsoft Lists, Microsoft365, Uncategorized /by Danish Dethoby Danish Ali Detho | O365 & Power Platform Solution Architect///
Microsoft Lists previously known as SharePoint Lists is the go-to option for maintaining and storing data in the world of O365 and its usage has grown even more ever since it has been integrated into MS Teams. MS Lists has become extremely easy to set up thanks to the introduction of features like import from CSV which lets you create a list from a CSV file and Built-in/custom List templates which lets you create a list using a predefined template. Microsoft has made MS Lists even more powerful by adding built-in power automate flows to some of the List Templates covering some of the most common scenarios associated with the out-of-the-box scenario-driven templates. In this blog, we will take a look at the List templates which come bundled with Flows and how to find them in Power Automate Portal.
Read more
AxioWorks Newsletter January 2023: Kicking off 2023 with some great content
/in Uncategorized /by Danish DethoHello 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?
We are working hard to make SQList bigger and better than ever in 2023 and are already deep in the development of a new release. We are going through a complete overhaul of some of the core components which will enable us to introduce some new connectors including connectivity to more destination databases such as Oracle which is in high demand.
The team has also started to bring some great content to you which includes bi-monthly videos on O365/SharePoint/Power Platform so do subscribe to our YouTube channel and follow us on Twitter and LinkedIn.
Peter Bradley, well known SharePoint consultant in the M365 world, has written a great article on how SQList brings more value to your SharePoint investments by enabling organizations to quickly get greater value from its data. Please do check out the article A pragmatic approach to obtaining value from your SharePoint data
Focus blog entry: Power BI Report Server : An On-Premises Report hosting Suite
Distributing and sharing Power BI was a pain point for organizations working in an on-premises setup and doesn’t want to set up a Gateway to expose the reports and their data to the cloud via Power BI Service. An On-prem hosting server is required in order to provide similar functionality to the on-premises users which lead to the emergence of the Power BI Report Server. It uses SQL Server Reporting Services technology for hosting reports On-Premises.
Read all about it in this month’s article on Power BI Report Server.
O365 feature of the month: Create MS List from a CSV List in MS Teams
Microsoft Lists aka SharePoint Lists have been widely used for maintaining and storing data in SharePoint and its usage has grown even more ever since it has been integrated into MS Teams. Microsoft has recently introduced some exciting new features that make it even easier to create new MS Lists and one of them is Import/Export Lists to CSV file.
If you want to know more details about this feature, check out the video blog explaining how it works: Create MS List via CSV file in MS Teams
Featured content
Here is a small selection of interesting articles/vlogs from the net.
Power BI REST API: What it is and Why it is Important
Power BI REST APIs can be used in programming (.NET or other languages), PowerShell, and other tools. Most of the use case for the APIs is through a programming language.
Read more…
Power Platform Wave 1 2023 Release: Top 10 Features You Need to Know!
In this video, you will learn about some of the best features that are released in the Power Platform Wave 1 2023 including
Read more…
How to create a Kanban board in SharePoint
Kanban boards are a great way to visualize and track the progress of any project. In Microsoft SharePoint, a newly introduced feature called Board view combined with the Lists app will allow users to create a Kanban-style board within SharePoint quickly and easily.
Read more…
That’s all folks, till next time.
A pragmatic approach to obtaining value from your SharePoint data
/in Uncategorized /by Francescoby Peter Baddeley | Microsoft Consultant///
Organisations have been storing data in SharePoint for more than 20 years. This data can be as simple as a List used by a small team or a complex system running multiple business processes. The challenge is that the simplicity of SharePoint can often lead to the creation of data silos. As with all data, the data stored in SharePoint becomes more valuable when it is interrogated in reports or integrated with other datasets. Read more
Power BI Report Server : An On-Premises Report hosting Suite
/in Uncategorized /by Danish Dethoby Danish Ali Detho | O365 & Power Platform Solution Architect///
Power BI has become the most widely used tool for reporting due its user-friendly interface which allows business users to generate sleek and customizable reports and interact quickly and easily with their data using simple drag-and-drop features and a plethora of customizable visualizations. Power BI Service further extended the capabilities by providing a robust report hosting cloud-based SaaS platform through which reports can be easily shared with colleagues for collaboration and made more accessible. However, if your organization has an on-premises setup and doesn’t want to set up a Gateway to expose the reports to the cloud then Power BI Service cant be used for hosting reports and an OnPremises hosting server would be required. In order to provide similar functionality to the on-premises users, Microsoft has introduced Power BI Report Server which uses SQL Server Reporting Services technology for hosting reports On-Premises. In this blog, we will take a deeper look at the Power BI report server, its features, and functionality, and how it is compared with Power Bi Service.
Power BI: A reporting tool like no other
Microsoft Power BI is a desktop-based reporting tool that enables you to collect, filter, combine, analyze and visualize and finally publish your data in form of a report or a collection of reports called Dashboard. Power BI provides a simple and user-friendly interface that can be used by business and power-users easily. Also, it allows for collecting data from a wide range of data sources. If you’re a business or power user who wants to work robustly on the data of your organization, then you will be using Power BI Desktop which is free to download.
Power BI Report Server: An On-premises Power BI Service alternative
Power BI Report Server is an on-premises report distribution technology offered by Microsoft Power BI Deployment Suit that is primarily used for hosting and sharing Power BI reports. Since it should be hosted on the machine in the company’s domain, it’s not an online service and therefore allows organizations to host and share reports OnPremises. It comes with a web portal which is an entry point to access Power BI reports and provides additional tools to create and host Power BI reports paginated reports, mobile reports, and KPIs. It consists of a web portal that provides features to view Power BI reports, paginated reports, Excel files, and KPIs, and navigate through the elements in your report server instance. You can also use the web portal to administer a single report server instance.
How it works
Note: Do check out the Hardware and Software Requirements for installing Power BI Report Server.
Power BI Report Server vs Power BI Service
Main Features
Licensing Requirements
Power BI Report Server is available through two different licenses:
Note: If you publish Power BI reports to Power BI Report Server, you also need a Power BI Pro license. You don’t need a Power BI Pro license to view and interact with Power BI reports on Power BI Report Server.
Conclusion
Power BI Report Server is an on-premises reporting server based on SQL Server Reporting Services technology which allows users to host their interactive reports fully on-premises without needing a Power BI website. You will not need a gateway, and all types of connections (Scheduled Refresh, DirectQuery, and Live Connection) are supported (Except the composite model). It does lack a lot of features if you compare it with Power BI Service but it does offer enough capabilities to make it desirable for organizations who want to keep their Power BI reports on-premises but are still able to share them with users.
AxioWorks Newsletter December 2022: Good bye 2022, welcome 2023!
/in Uncategorized /by FrancescoHello Reader,
Welcome to the December 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?
December has been a good month. In the first couple of weeks it was business as usual, busy, busy, busy. Then, in a matter of days, everything slowed down to a trickle; no customers requiring support, few daily emails in the inbox… at last, a well deserved break! So, how was this year?
2022 has been a busy year. With the Covid crisis behind us, we have worked hard to regain the momentum we lost in the previous two years. We’re not 100% back to pre-Covid levels yet but it’s getting there, and next year is looking good!
In terms of deliveries, we were able to deliver the regular maintenance and upgrades for SQList and we released SQList Online, the cloud version of our SQList, which is showing very promising signs. Customer support (a priority as always) took a good chunk of our resources and, based on the feedback we received, we must have done well.
This year we also expanded our Sales and Marketing team and got them up to speed, ready to start the next year running. They have already been in touch with some of you, and we must thank you for the very positive feedback you gave on SQList.
And the company growth does not end there, in 2023 we plan to expand our development team too and start working on yet another version of SQList as well as other projects.
We have great expectations for 2023 so keep watching this space! In the meantime,
HAPPY NEW YEAR from all of us at AxioWorks!
Focus blog entry: AxioWorks SQList is now available online
This year we launched SQList Online! The cloud-based software as a service (SaaS) version of SQList, our on-prem application that makes it extremely easy for organizations to store and synchronize SharePoint On-prem/SharePoint Online data into SQL Server databases, allowing them to efficiently generate reports using their preferred reporting tools like Power BI, Excel, or SSRS by connecting directly to SQL tables.
Read all about it: AxioWorks SQList is now available online.
SQList 30-second feature: Keep deleted SharePoint items in SQL Server with AxioWorks SQList
If you have very large SharePoint lists that have become difficult to manage due to their size, you may want to trim them but still have all data available to reporting tools or other LOB systems.
In this video you will see how you can use SQList to synchronise your SharePoint lists with SQL Server tables and keep deleted items in the table.
Click this link for a short video.
Featured articles
Here is a small selection of interesting articles from the net.
How to embed a Microsoft List form in a SharePoint page
If you are looking for a solution to increase the adoption of a new list in SharePoint or Microsoft Lists, getting it embedded in a new page might be a good approach. By embedding the new item form in a SharePoint page, users will be able to add data to list without leaving the page context, making the process faster and less disruptive.
Read more…
How Much Data Can You Load Into Power BI?
Power BI can handle large data volumes, but just how much data can you load into Power BI? Can Power BI handle big data? How big is “big” anyway?
Read more…
Enable SQL Server system versioning for SQL tables generated by SQList
In this article, we are going to see how to add SQL Server System Versioning to SQL tables created by SQList.
Read more…
That’s all folks, till next time.