Power BI Dataflow saves and closes successfully, but Refresh returns Credentials Not Found

[JWolmanSymplr]

I have a Power BI Dataflow which saves and closes successfully and returns my data correctly, but when I save and close and try to Refresh the Refresh fails with a Credentials Not Found For Data Source.

My dataflow started as a Blank Query and I put in the following:

let

rollingDate =Date.ToText(Date.AddDays(DateTime.Date(DateTime.LocalNow()),-102),"yyyy-MM-ddZ"),

Source = Json.Document( Web.Contents ("https://analytics.dev.azure.com/[company]/_odata",[ 

RelativePath = "v3.0-preview/WorkItemSnapshot?", 

Query=[ 

#"$apply"="filter(DateValue ge " & rollingDate & " and Date/DayOfWeek eq 5 and WorkItemType in ('Feature') and Project/ProjectName in ('My Project') and Area/AreaPath ne null and Iteration/IterationPath ne null) /groupby((DateValue,WorkItemType,Project/ProjectName,Area/AreaPath,State,Iteration/IterationPath),aggregate($count as WorkItemCount, Effort with sum as SumofEffort, StoryPoints with sum as SumofStoryPoints))"

]])),

value = Source[value],

#"Converted to Table" = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

in

#"Converted to Table"

This returns my data and I can Save and Close, but the dataflow does not refresh.

When I check the Options and the Project Data Load, the Data gateway only gives me (None) and two of my on-premise SQL server gateways. I cannot add or select anything valid for this query as this is an Azure DevOps query.

How can I use this query and yet still have my dataflow Refresh?

[lbendlin]

Small comment: Remove the question mark from the RelativePath

How are you authenticating, via OAUTH2?

[JWolmanSymplr · Accepted solution]

The question mark works, what I had to do was create a new dataflow and select a generic OData feed query, then add my query above using the Let syntax. If I tried to create an empty dataflow and then create a blank query using my query from above it would not work.