Re: Limited data from Dynamics 365

Anonymous · ‎02-25-2020

Hi there!

I want to limited the data that I download from dynamics 365 since the URL, how can i do it?

Thanks

Regards.

V-lianl-msft · ‎02-25-2020

Hi @Anonymous ,

Based on your description, you want to limit the dynamics 365 data obtained from the web URL.

You can transform the data in the edit query or refer to this Blog.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler · ‎02-25-2020

Are you connecting to the OData endpoint? You should be able to limit the data in Query Editor.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎02-25-2020

I want to do it with URL, I've been trying with this URL ( https://---operations.dynamics.com/data/InventJournalTrans?$top=20) but i got the following error.

Limit data from Dynamics 365