Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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"])
In Graph explorer i can see the correct output, but when i'm using it as a oData it looks like this:
No one able to help me in the right direction?
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |