OData Feed with SharePoint Document Libraries and PowerBI

Question

Using the OData feed in PowerBI I have successfully connected a SharePoint 2016 Online document library to PowerBI. I want a graphical report, bar chart or pie chart for this example, to report on a custom column I have created called document type. However, when I select the field I want to report on in PowerBI and then select the bar chart graph icon nothing happens. No bar chart displays with my document type data.

Can you add graphical reporting to custom columns created in a document library in SharePoint Online 2016?

Answer 1

Hi Michael,

As the issue is about displaying SharePoint data in Power BI, that’s more related to the settings in Power BI, we suggest you go to our Power BI Forum so that the support their can help you more professionally and efficiently.

Thanks,

Rena

Answer 2

Hi Michael,

Do you want to embed a Power BI report to a SharePoint Online site? If so, here’s a reference: Embed with report web part in SharePoint Online.

If this is not related to your requirement, to clarify the problem, please provide detailed steps how you reproduce the issue with screenshots.

Thanks,

Rena

Answer 3

I do not want to embed a Power BI report in SharePoint. I want to pull data about a SharePoint document library into Power BI. I have successfully done this using the OData Feed, but i am not able to graphically dispaly this information in Power BI.

For example, if I created metadata in SharePoint about departments types, HR, Accounting, Finance, how do I display how many time these departments come up in Power BI with a bar chart. 

I want to graphically display the frequency of particular metadata names from a custom column created in a SharePoint document library.