Forum Discussion
Why would pulling from an API via a Web Data Source not allow data refresh in the Power BI Service?
"You can't schedule refresh for this dataset because one or more sources currently don't support refresh" is what I see in the Power BI Service (Pro level). Below is an example of the data source I am using currently. Any help to understand this is greatly appreciated in advance!
Source = Json.Document(Web.Contents("https://some.url.com/all_things?format=json&page=" & Number.ToText(Page)))Got this figured out, apparently Power BI is helpful and was trying to validate my URL which I am constructing before it was constructed. I learned that I need to pass in with a Query function and not put that in my URL. Hope that helps someone else!
2 Replies
Got this figured out, apparently Power BI is helpful and was trying to validate my URL which I am constructing before it was constructed. I learned that I need to pass in with a Query function and not put that in my URL. Hope that helps someone else!
