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 O...
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.