Our Favourite Picks from Power BI Global Summit 2023

/in , /by

by 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 March 2021: Our first!

/in , , , , , /by

We have just sent out our first newsletter and, being it our first one, we thought we dedicate a post to it. All future ones will go out just by email so, if you find this one interesting, please do subscribe!!!

First of all, thank you to all of our current subscribers! We hope you will find this content interesting, We are new at this and very excited about it.

Our plan is to make it a monthly issue and include updates about our company and products, interesting and relevant articles, and anything else we think you may find interesting like – in this issue – the winner of the Logitech C930-E Business Webcam prize draw!

Read more

7 Reasons why SQL Server tables are a better option for reporting then SharePoint Lists

/in , , , , , , /by

SharePoint Lists plays a pivotal role in any SharePoint development primarily because it is the preferred source of data storage in SharePoint. All the great features like security permissions trimming, views, various types of columns, data validations, and entry forms that come out of the box and can be easily configured give SharePoint Lists an edge over any other data storage options. However, there are several scenarios that make SharePoint Lists less desirable especially when it comes to reporting. Reporting becomes very critical when we store business-critical data in SharePoint since it is vital for business users to make decisions. E.g. if you are storing customer orders in SharePoint Lists then soon you will need to develop some reports to get insights on your customer buying trends.

Read more

AxioWorks SQList New Version

New version of AxioWorks SQList released (6.2.1.0)

/in , , , , , , , /by

A new version of AxioWorks SQList is out today!

It’s been a while since we released a new version, it was back in April 2020 and a lot has happened since! (and not much of it was good…)

Anyways, here we are, version 6.2.1.0 is out, let’s take a look at what comes with it.

Read more

Power BI Reports from Microsoft Lists

Generate Power BI Charts from live MS Lists data

/in , , , , /by

In our previous article on MS Lists, we did a detailed introduction including some of the great features which can help any business in implementing use cases like issue tracking and inventory management.

In this blog, we will use MS Lists to create an issue tracking solution using an out of the box template and then we will use SQList to synchronize data between MS Lists and SQL Server database. Finally, we will use Power BI to generate charts.

Read more

SharePoint lists to PowerBI

Power BI Master/Detail Report from live SharePoint data

/in , , , , /by

In the real-world, reporting often includes master/detail scenario in which a master list item is selected in order to get more details about the entity. In SharePoint, master data will be stored in a list that contains a lookup column of detail list/s, and getting data from multiple lists would require multiple data sources and then modelling their relationships in Power BI. In this blog, I will show you how easy it is to achieve a master-detail scenario on live data coming from SharePoint lists using AxioWorks SQList. We will start off by looking at the lists which we are going to use in this scenario and followed by how we can use SQList to synchronise data between SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate a report which shows master data in one table and details in the other based on a selection.

Read more

Blog: Generate Power BI chart from SharePoint lists

Generate Power BI Charts and Reports from live SharePoint list data

/in , , , /by

In this blog, I will show you the best way of creating a Power BI chart on live data coming from SharePoint lists. We will start off by looking at the lists which we are going to use for this demo and followed by how we can use SQList to synchronize data between SharePoint Lists and SQL Server database and to finish things off, we will look at how to generate our reports and charts much faster.

Read more

Come and visit us at SharePoint Saturday in Leicester

/in , /by

We are proud to be one of the Gold sponsors of  SharePoint Saturday in Leicester on Saturday, November 16, 2019.

Why not come to our stand and meet us? We’ll be happy to give you a demo of SQList and discuss how it could fit into your organisation.

We will also be giving a presentation on The best way to access SharePoint data from Power BI, SSRS, and other BI tools, where we will be demonstrating how we can easily create a Power BI chart on live data from SharePoint lists in minutes.
And if you cannot make it to Leicester, you can watch a preview on our blog.

SharePoint Saturday is free to attend and will be packed with content including SharePoint, Office 365, Teams, Azure, PowerApps, Flow, and Yammer. As an attendee, you’ll have the opportunity to attend multiple sessions and network with some of the best educators in the industry.

Read more

The best way to access SharePoint data from Power BI, SSRS, and other BI tools

/in , , , , /by

Watch our presentation, where we are going to show you the best way to access live SharePoint data from any reporting and BI tool, like Power BI, SSRS, or Crystal Reports.

Read more

The Rise of SharePoint as a BI tool

/in , , /by

SharePoint started off as an enterprise content management system but over the years, it has become an integral part of business decision making in organizations. As the user-base of SharePoint grew exponentially so did the uses of it and soon SharePoint community started to realize that there is a lot more to it then content management and that’s where SharePoint started to become more of a platform for Content/Document management, team collaboration, Project Management, etc which all falls under the umbrella of what we call a modern workplace. SharePoint has become a great presentation layer and central repository for content which are integral for any business intelligence solution. As such it was natural for Microsoft to introduce a suite of BI features built within SharePoint to help business users in utilizing data efficiently to make business decisions, but the question is are they enough to consider SharePoint as a BI tool? In this article, we will start by looking at key BI capabilities every Modern workplace organization is craving for and then analyze the BI capabilities provided by SharePoint and are they enough to make SharePoint a preferred BI tool.

Read more