Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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 |
---|---|
60 | |
58 | |
54 | |
36 | |
33 |
User | Count |
---|---|
79 | |
66 | |
45 | |
44 | |
42 |