Posts

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

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

Power BI using SharePoint List VS SQL Tables

/in , , , , /by

Power BI is a no code analytics and reporting tool from Microsoft which allows business users to generate sleek and customizable reports and interact quickly and easily with their data using simple drag-and-drop features. It is an extremely feature rich yet user-friendly reporting tool which can also be used for creating live dashboards and then sharing them with your colleagues or embed them in your app, website, or SharePoint portal. It is compatible with over 65 different data sources out of the box including both on-premises and cloud products.

Read more

Comparison of BI Tools: Power BI vs Cognos vs Crystal Reports vs SSRS

/in , , , , , , /by

Which is the best Business Intelligence (BI) tool available? Why is it the best and what distinguishable features makes it the best one? What are the alternatives? What is the current client base of this tool? Is this BI tool the right one for your business as well? What should you be looking for when evaluating BI tools? Will your business analyst or end users be capable enough to extract desired information from this tool?

In this blog, we evaluated some of the most popular BI tools out there, provided an overview and compared features, hopefully helping you to make the right choice of BI tool to meet your business requirements. A first step to finding the best tool for your company.

Read more

How to publish SharePoint data to Power BI using the enterprise gateway

/in /by

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.

Read more

Power BI Desktop and Power BI Server March 2018 Updates

/in /by

This month Microsoft have released a new production ready version of Power BI Report Server as well as a updates to Power BI Desktop with new visuals and a variety of connectors moving to general availability.

Read more

Power BI with SharePoint data: The Ultimate Guide

/in /by

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 is a cloud-based service that enables to collect, filter, combine, analyse and visualise and finally publish your data in form of an analysed report or a visualised report. Power BI provides a simple and user-friendly interface that can be used by business and power-users easily. Also, it allows collecting data from wide range of data sources. If you’re a business or power-user who wants to work robustly on data of your organisation, then you will be using Power BI Desktop or Power Bi Desktop Pro which is free to download.

In this blog, we’re going to use Microsoft Power BI tool to collect data from various sources such as SharePoint, web services, OData and SQL Azure. we’ll explore Power BI Desktop tool to build productive and creative reports. Also, we’ll use Power BI service to publish reports and set up automatic data refresh so everyone can see updated information. So, let’s get started!

Read more

POWER BI: SHAREPOINT REAL TIME REPORTS AND DASHBOARDS

/8 Comments/in /by

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 to:

  • Create a Power BI report on  a SharePoint list
  • Configure the Power BI report to use direct query on the SharePoint data to keep the report up to date
  • Embed the Power BI report in SharePoint online

Read more