cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
michaelch
New Member

Using OData Feed with SharePoint

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: Using OData Feed with SharePoint

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.Smiley Happy

r5.PNG

Regards

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

Re: Using OData Feed with SharePoint

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.Smiley Happy

r1.PNGr2.PNG

 

Regards

michaelch
New Member

Re: Using OData Feed with SharePoint

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. 

Microsoft
Microsoft

Re: Using OData Feed with SharePoint

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.Smiley Happy

r5.PNG

Regards

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors