AxioWorks Blogs
AxioWorks news, product updates, useful articles, hints and tips on how to make the most of your SharePoint data and Power BI Reports.
Generate Excel charts and reports from live SharePoint list data
In this blog, I will show you the best way of creating a chart in Ms Excel 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…
Generate Power BI Charts and reports from live SharePoint list data
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…
Which industry hold the lion’s share of SharePoint usage and why?
SharePoint, which was once written off as a failed CMS incapable of gaining a significant user base has now become one of the most widely used ECM and Collaboration product with more than 250,000 organisations including (85% of fortune 500 companies) and over 190 million people using SharePoint/SharePoint Online. One of its main success factors…
Who is the king of SharePoint BI and reporting tools?
Over the past few years, Business Intelligence and Insights in SharePoint has become one of the most desired features especially for enterprise customers. The user voice on improved reporting features for content and usage of SharePoint has led to several ground-breaking tools including Microsoft very own Power BI which is one of the leaders in…
How to publish SharePoint data to Power BI using the enterprise gateway
The enterprise gateway provides the facility to access data into the Power BI that reside on an on-premises network, it validates connection request and allows access to only those users’ requests which meets certain criteria. It also secures data, password and access request by doing encryption and compression of the data which passes through it.
SharePoint 2016 and SSRS 2016/17: The ultimate guide
In this blog post we will look at SSRS 2016/2017 with SharePoint 2016 in detail and in particular: What SSRS is and how it fits into the Microsoft BI stack The various components that make up the SSRS toolset What’s new in SSRS 2016/2016 How to set-up SSRS to be used with SharePoint 2016 How…
Using Tableau to report on SharePoint lists and libraries: A step-by-step guide
Tableau is one of the most renowned and accepted Business Intelligence tool for visually analysing the data by organisations all over the world. Tableau allows its users to create and distribute an interactive dashboard depicting the trends, variations, and density of the underlying data either in the form of graphs or charts. Tableau can connect…
Power BI with SharePoint data: The ultimate guide
Nowadays, we deal with huge amount of raw data to make business decisions using Business Intelligence technology that helps in accelerating and improving decision-making, optimizing business processes, gaining new revenues and competitive advantage over business entrants. There are many BI tools are available in the market such as Tableau, Qlik, Power BI etc. Microsoft Power BI…
Power BI: SharePoint real time reports and dashboards
Microsoft Power BI provides a powerful way to visualise SharePoint data and build reports and dashboards on SharePoint lists and libraries. With the introduction of a Power BI web part (and the embed code) we can now also integrate these Power BI assets in our SharePoint sites. In this blog post we will cover how…
How to import SharePoint libraries into Power BI and create links to the documents
If you have tried to import from SharePoint to power BI you have probably realised you can import Lists and folders but not libraries. In this post, which is based on a video by Ruth Pozuelo Martinez who is a microsoft MVP we’ll look at the Ruth’s suggested steps for doing the following: Export the…