Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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% of the other columns).
When I refresh the data however, it still takes forever to complete, about 700+mb to load. In all there is just over 90K rows, so this seems unnecessarily large. Is there something I am doing wrong? Any advise much appreciated.
Hi @adam_mac ,
If the source table was loaded or quoted multiple times before filtering columns, you can try to use Buffer functions like Table.buffer() etc. to buffers it in memory to improve performance.
Refer:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.