Forum Discussion
How do I only pull the fields I want from dynamics?
When I connect dynamics to power bi, it pulls hundreds of columns. This slows the refresh time since I dont need 90% of the columns. Is there a way to only pull the columns I need?
sevenhills
Super User
Super Usera) If you are using ODATA connector ~ $select=
b) https://www.inkeysolutions.com/blogs/power-bi-how-to-fetch-dynamics-365-ce-data/
check XRM tool box
Hope this helps