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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Netrelemo
Helper IV
Helper IV

DataSource.Error: OData: Unsupported query option encountered: $expand

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

 

Netrelemo_1-1674688706060.png

 

 

Netrelemo_0-1674758194712.png

 

 

What am I doing wrong? How do I solve it? 

3 REPLIES 3
Newtten
New Member

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.  

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.