Get SharePoint List items in Power BI

In this article, I will show

How to query data from SharePoint List / Library in Power BI.


Get SharePoint List/Library Using OData Feed

First, let’s briefly define the OData?

  • The Open Data Protocol (OData) is a data access protocol for the web.
    • OData provides a uniform way to query and manipulates datasets through CRUD operations (create, read, update, and delete).
    • OData defines an abstract data model and a protocol that let the client access information exposed by SharePoint.

Steps

Continue reading “Get SharePoint List items in Power BI”

Advertisements

Show and Sort Slicer By Month or Quarter Name in Power BI

In this article, we will show

How to display and sort a Slicer control by Month or Quarter Name in Power BI? 

A slicer is a powerful alternative way to filter the dataset shown on the page.


Scenario

In PowerBI, when you try to use the slicer to filter by a date field, it shows the year of this date field by default.

Slicer By Year in Bower BI
Continue reading “Show and Sort Slicer By Month or Quarter Name in Power BI”