Forum Discussion
Refresh taking forever for only 2 columns
Hi, a topic I’m sure has been covered a million times. I am drawing in data from an OData connection and have created a model with only 2 columns, an ID column and a Country column (I removed 99% ...
Looks like it is loading the whole table before the select columns step. Please try the Json.Document(Web.Contents() approach described in this article with a $select clause for your two columns. If it works, please report back with how much faster it is.
How to retrieve OData v4 fast in Power BI - Microsoft Dynamics CRM Community
Pat
thanks yes this make sense as to why it is taking so long. I have given the json technique a go but cant seem to make it work. I believe its because the CRM i am pulling from has no API and the URL i am using is https://my000000.crm.ondemand.com/sap/byd/odata/v1/c4codata/ which has odata stated in it.
