Forum Discussion
Power BI API with Dynamics 365
Hello all, Dynamics SAAS environments limits data size for API calls. As a business analyst without IT/IS background I got things working to the below degree. An API call out of Power Query ...
Uereka, Solved!
The magic is in the use of spaces or %20.
The correct syntax turned out to be:
No need to use single and double quotes around the variables.
Text strings must be separated by space which are translated as %20 in the query. Between the ge/lt strings and the quote sign make sure the is a space, also between the closing quote after the first variable (startDate) and the and string leave a space. In this respect the proposed solution by Syndicate Admin was correct
A lot of trial and error to find this.
All references I found are not clear in this respect and copying the proposed solution syntax was not successful.
As always: the devil is in the detail!
On to the next challenge.