Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
POWERShawn
Regular Visitor

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)))
1 ACCEPTED SOLUTION
POWERShawn
Regular Visitor

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!

View solution in original post

2 REPLIES 2
POWERShawn
Regular Visitor

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!

Anonymous
Not applicable

could you please provide an example of this Query Function of yours?

I am new to M language and I have this problem with function as part of URL...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors