Forum Discussion

Netrelemo's avatar
Netrelemo
Helper IV
3 years ago

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...
Need Help
  • Netrelemo's avatar
    Netrelemo
    Helper IV
    3 years ago

    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.