Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I want to use a dynamic URL for my report. I created a URL parameter.
the hardcoded version works fine and looks like this:
=Json.Document(Web.Contents("https://<organization name>.crm4.dynamics.com/api/data/v9.1/opportunities?$select=name"))
I changed it to this:
= Json.Document(
Web.Contents(strURL,
[RelativePath = "opportunities",
Query=
[$select="name"]
]
)
)
Issue is that the syntax does not allow $ in the query parameters but is required to use in the web api for D365 CE.
Without the $ sign the syntax is ok, but then the API is not working properly (see error below)
Any suggestions are welcome
Solved! Go to Solution.
Change:
[$select="name"]
to
[#"$select"="name"]
Thanks Artemus !
it works
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.