Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I am using PowerQuery on a OData source pointing at MS Project Online.
One of the columns in my query is type "Record".
When I expand the column, I can choose the columns I want, but the result is the error as titled...
DataSource.Error: OData: Unsupported query option encountered: $expand
What am I doing wrong? How do I solve it?
if you right click on the column you would like to expand, and select unpivot then you will be able to expand it
Thanks @amitchandak,
I have seen those links already, but they are not helpful.
Maybe I should rephrase my question: How do I convert a column of data type records to a column of data type table. I'm not expecting a solution, since the problem is not actually inPowerQuery, but rather in the underlying data provider.
The PowerQuery function
= Table.ExpandRecordColumn(Filtered, "Time", {"TimeMonthOfTheYear"}, {"Time.TimeMonthOfTheYear"})
would theoretically do the trick, but since the data provider bombs out, it won't work. So now I'm wondering if I must have some sort of custom function approach to read each record and extract this one field that I want from the record.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |