Forum Discussion
D365 CRM Connection Slowness (TIP)
Hey All!
This is a tip for you folks using an ODATA feed to pull information from D365 CRM.
If you things appear to be unusually slow & the network checks out, it may be due to queries that unfold tables in power query.
I recently started unfolding & really didn't have issues until a few days ago. Changes were taking hours to update.
After reviewing this POST (Hitachi site) I pulled in the tables I wanted to get information from rather than simply unfolding. Cleared the problem right up; went from waiting hours to everything updating in about a minute.
Unfolding seems efficient, but in this particular case it wasn't (time-wise at least).
HI Anonymous ,
In my opinion, the simple way to increase loading data speed is add URL conversion filters to odata feed connector.(optional parameter, you can use it to reduce records amount that power bi received when you design report)
After you finish design your report and ready to publish it, please don't forget to remove url conversion filters to display full records on power bi service side.
URL Conventions (OData Version 3.0)
Regards,
Xiaoxin Sheng
1 Reply
HI Anonymous ,
In my opinion, the simple way to increase loading data speed is add URL conversion filters to odata feed connector.(optional parameter, you can use it to reduce records amount that power bi received when you design report)
After you finish design your report and ready to publish it, please don't forget to remove url conversion filters to display full records on power bi service side.
URL Conventions (OData Version 3.0)
Regards,
Xiaoxin Sheng