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.
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?
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |