Using OData Feed with SharePoint

[michaelch]

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?

[v-ljerr-msft]

Hi @michaelch,

Based on my understanding, if you have successfully loaded the custom column "document type" to your data mode in Power BI, then you should be able to show it on the report.

---

---

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.

How do you want show the data of "document type" column for the bar chart, as the Axis, or Value? If you want it shown as the Axis for the bar chart, you still need to specify a column for the Value field of the bar chart, or the bar chart won't display anything.

Regards

[michaelch]

Maybe a bar chart is the wrong graphical representation. In SharePoint Online 2016 I have created a costum column in a document library to track document types. What I would like to do in Power BI is to show graphically how many of a certain docuemnt type I have.

12 of doc type 1

3 of doc type 4

8 of doc type 5

2 of doc 6

etc.

I was hoping that Power BI could just sum up the total count of a particular doc type and then display this in a bar chart. The doc type would be the axis on the bar chart. 

[v-ljerr-msft · Accepted solution]

Hi @michaelch,

In your scenario, you should be able to use a clustered bar chart, then put doc type column in Axis field, Count of doc type in Value field for the chart like below.

Regards