Forum Discussion
PowerBI Refresh Slow on Merged Tables
When refreshing data in Power BI Desktop, make sure that you also disable the backgroud data option.
In addition, you can get OData feed URL from your Dynamics 365 environment by going to Settings > Customizations > Developer Resources > Instance Web API > Service Root URL.
Reference:
https://community.dynamics.com/crm/b/thecrmwizondynamicscrm/archive/2018/01/31/connecting-power-bi-to-dynamics-365-customer-engagement-odata
Regards,
Lydia
Hi,
Anonymous
It did not work. It is still really slow.
Is there anything else I can try?
Many thanks!
Do you switch to use OData option? Also please import the necessary columns and rows, and check if try to use DAX instead of merge queries feature.
Regards,
LydiaAnonymous
The OData link does not work in my PowerBI desktop, it gave me the following error. Actually there was another type of error too...
Speaking of using the DAX, I also encountered another problem and posted my question in this thread:
Many thanks!