Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Dears,
I am trying to pass $filter as query parameter to Web.Contents, so that I can enable scheduled refresh.
url = GetGraphURL(AzureKind)&"/"&TenantName&"/users",
queryParameters = [
#"api-version" = 1.6,
#"$filter" = "objectId eq '"&principalId&"'"
// Add any other query parameters here
],
Source = Json.Document(Web.Contents(url,[Query=queryParameters])),
The above does not work.
However, if I pass url without Query option in Web.Content, as shown below, it works.
url = GetGraphURL(AzureKind)&"/"&TenantName&"/users?api-version=1.6&$filter=objectId eq '"&principalId&"'",
Source = Json.Document(Web.Contents(url)),
But this does not support scheduled refreshing.
Please advise.
Thank you.
what is the error message?
BTW, for scheduled refresh you will also need to use RelativePath.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.