How do I only pull the fields I want from dynamics?

[Anonymous]

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]

a) 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

[mahoneypat]

Are you using the Odata connector?  If so, I think if you make Choose columns step your second step, it will "fold" that back to the source and only retrieve your selected columns.  If that doesn't work, you can construct a more detailed URL for a web call using $select= to bring back only the columns you need.

Querying Dynamics 365 OData (redware.com)

Pat