Object type is a page for table Object ID 132. So there should be a possibility to filter out some of the unnecessary columns.
I played a bit with the Create Data Set to filter out most of the columns in another table, however ID 132 doesn't seem part of the data set for this tool.
What other tools do we have to filter Odata when importing it? Adding a select function at the end of the Odata link such as this?
$select=No,Order_No,Sell_to_Customer_No,Sell_to_Customer_Name,Your_Reference,Ship_to_Code,Ship_to_Name,Ship_to_Post_Code,Ship_to_Country_Region_Code,Ship_to_Contact,Posting_Date,Location_Code
Currently playing with a table modified with Create Data Set, it's a bit sluggish, but it could also be the browser power query they are making us use in Datamart. We'll import more and see how it fares.
Thanks,
