Forum Discussion
Using $Select to fetch only specific columns
I am trying to only fetch certain columns from my initial fetch of a table in Dynamics and even though it is not giving any error, but it is still bringing in all the columns.
let
// Construct OData URL with $select to fetch only required columns
URL = "https://xxxxxxx.crm4.dynamics.com/api/data/v8.0/quotes?$select=dwtc_totalamounthidden,createdon,quoteid,_opportunityid_value,statecode,statuscode,dwtc_netareasqmtr,dwtc_barterdiscount",
Source = OData.Feed(URL),
// Rename columns directly after fetching
#"Renamed Columns" = Table.RenameColumns(Source, {
{"_opportunityid_value", "Opportunity ID"},
{"dwtc_totalamounthidden", "Amount - Quote"},
{"dwtc_netareasqmtr", "Net sqm"},
{"statuscode", "Status Code"},
{"createdon", "Created On"},
{"quoteid", "Quote ID"},
{"statecode", "Quote State"},
{"dwtc_barterdiscount", "Barter"}
}),
// Reorder columns as needed
#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns", {
"Quote ID", "Opportunity ID", "Amount - Quote", "Net sqm", "Barter",
"Status Code", "Quote State", "Created On"
}),
// Apply any further transformations or filters
#"Filtered Rows" = Table.SelectRows(#"Reordered Columns", each ([Opportunity ID] <> null)),
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows", {{"Created On", type date}})
in
#"Changed Type"
2 Replies
Hi fahadarshad - $select parameter is passed correctly and formatted with valid column names from right entity.
https://xxxxxxx.crm4.dynamics.com/api/data/v8.0/quotes?$select=dwtc_totalamounthidden,createdon,quoteid
Hope the URL is correctly formatted and tested before using it in Power BI test your OData URL in a web browser or a tool like Postman API or others and clear Power BI’s cache to prevent it from using old data.try to remove unnecessary columns after fetching the data if needed.
Try the above points and let know
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!The url is correct and so are the column names but it isn't selecting those specific columns.
