Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Marcus_sweden
Regular Visitor

OData.feed

Hi,
I have a small question regarding OData.feed.
Source is Microsoft Graph, and with a simple OData I get two columns correctly, and if I add “MoreColumns” it gets all columns from the graph but all with the value null.
How do I get correct value from the ”MoreColumns” data?

This is the query I’m using:
(Which is working but not with all data)

 

=OData.Feed("https://graph.microsoft.com/beta/groups/group-id/members", null, [MoreColumns=true,Implementation="2.0"])

4 REPLIES 4
Marcus_sweden
Regular Visitor

In Graph explorer i can see the correct output, but when i'm using it as a oData it looks like this:

 

Marcus_sweden_0-1671534881765.png

 

Marcus_sweden
Regular Visitor

No one able to help me in the right direction?

css207
Frequent Visitor

MoreColumns

It's MoreColumns in real query, just made typo above, it's corrected. 
if I'm not using MoreColumns I only get 2, but by adding it, I get all columns but with null value. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors