PowerBI Refresh Slow on Merged Tables

Question

Hi Guys,&nbsp;Does anyone know where I can find the link of Dynmaics 365 Odata feed, in order to have PowerBI directly get data from Dynamics 365?&nbsp;Right now my PowerBI directly connects Dynamics 365 financial online service. It becomes slower and slower when I refresh data tables, especially merged tables. I have tried to disable the Auto Date/Time and already removed most unecessary columns, it is still really slow to refresh&nbsp;I heard that using the OData feed to connect to the Dynamics 365 would be refreshing a lot faster! However, where I can find the OData feed link in Dynamics 365?&nbsp;&nbsp;Or is there any other ways to have PowerBI refresh significantly faster?&nbsp;Many thanks!

anonymous · Answer

FreonYz,
When refreshing data in Power BI Desktop, make sure that you also disable the backgroud data option.In addition, you can&nbsp;get OData feed URL from your Dynamics 365 environment by going to Settings &gt; Customizations &gt; Developer Resources &gt; Instance Web API &gt; Service Root URL.Reference:https://community.dynamics.com/crm/b/thecrmwizondynamicscrm/archive/2018/01/31/connecting-power-bi-to-dynamics-365-customer-engagement-odataRegards,Lydia

freonyz · Answer

Hi,Anonymous&nbsp;It did not work. It is still really slow.Is there anything else I can try?Many thanks!&nbsp;

anonymous · Answer

FreonYz，
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,Lydia

freonyz · Answer

Anonymous&nbsp;The OData link does not work in my PowerBI desktop, it gave me the following error. Actually there was another type of error too...&nbsp;Speaking of using the DAX, I also encountered another problem and posted my question in this thread:https://community.powerbi.com/t5/Desktop/Can-t-create-a-relationship-between-two-columns-because-one-of/m-p/355104#M159895&nbsp;Many thanks!

Forum Discussion

PowerBI Refresh Slow on Merged Tables

4 Replies

Related content

Merging PowerBI Files

MERGE QUERIES

PowerBI refresh error

Merge taking too much time and refresh is failing

PowerBI semantic Model refresh