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.
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…
5 ways to export SharePoint data to SQL Server
SharePoint provides us with a great way of capturing and managing data which has seen a huge increase in business data stored in SharePoint On Premise and SharePoint Online lists and libraries. This often means we have the requirement to report against this data. SharePoint doesn’t always make this easy for us! We can install…