Issue while using a shared dataset via ODATA in Power BI Report Server/Desktop

I know this is old, but I didn't see any explaination of solutions out there. I just had this issue and I solved it. The "More Columns" in advanced is important when creating your odata source. Then you get two columns in the Power Query Editor, ID and More Columns. In the header of the More Columns, to the right of the text there is a button that looks like two arrows going up then pointing away from each other (ie [↰↱]).

Clicking on that button, the Power Query Editor will open a window asking you what columns you want to include in the expansion with all selected by default. Hitting ok on that window adds all of the columns in the More Columns/Record cells to your Power Query Editor table. The M function the button calls is Table.ExpandRecordColumn. After expansion with the button, your code in Advanced Editor will look something like this. 

let
    Source = OData.Feed("https://sample.com/Reports/api/v2.0/datasets(DatasetID)/data",null, [MoreColumns=true]),
    #"Expanded More Columns" = Table.ExpandRecordColumn(Source, "More Columns", {"ID", "TITLE", "PRIORITY", "IMPACT", "MODIFIED", "CREATED"},

in
    #"Expanded More Columns"

 Hope this helps the next person who runs into this issue. 

TL;DR: The More Columns column is expandable via the button in the column header. [↰↱]