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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
alxrz
Regular Visitor

Web.Contents is not working with Scheduled Refresh [BUG]

I'm trying to use function Web.Contents which is supported (as "Web") according to https://support.powerbi.com/knowledgebase/articles/474669-refresh-data

 

Here's my part of code:

...
url = Text.Combine(prepared_url, ""), // goes to https://www.googleapis.com/analytics/v3/data/ga
contents = Web.Contents(url),
jsR = Json.Document(contents),

...

 

I've tested line by line and starting from 2nd line, once it's included in a query, then scheduled refresh is not available any more!.

 

BUT in my another query (in the same dataset) I used Web.Contents with the same structure (naming is different) and scheduled refresh was available!. So I believe I'm allowed to use only one Web.Contents in one dataset OR except making calls to "googleapis"?

 

P.S. as suggested in one of the threads I've tried to use dataset in shared onedrive (opposed to publish now button in desktop version).

 

Please help, how to make it work?

1 ACCEPTED SOLUTION
curth
Power BI Team
Power BI Team

The reason this isn't working is because you're generating the URL programmatically. For the most part, the URL will need to be a literal for refresh to work. If you need to construct an URL from a literal base path and a variable relative path, you could try specifying the base path as the first argument to Web.Contents and then using the RelativePath query option for the variable part. This has the limitation, though, that the base path by itself must be accessible or the "Test Connection" process will fail.

View solution in original post

3 REPLIES 3
curth
Power BI Team
Power BI Team

The reason this isn't working is because you're generating the URL programmatically. For the most part, the URL will need to be a literal for refresh to work. If you need to construct an URL from a literal base path and a variable relative path, you could try specifying the base path as the first argument to Web.Contents and then using the RelativePath query option for the variable part. This has the limitation, though, that the base path by itself must be accessible or the "Test Connection" process will fail.

I think I have a similar problem, when specifying headers in the web.contents call. Do you guys mind having a quick look? 

http://community.powerbi.com/t5/Service/web-contents-with-specified-headers-works-in-PBI-desktop-but...

Do you have any examples of a working parameterized web query where scheduled refresh is allowed?  I am not finding any information on the "RelativePath" query option for the variable part.  

If we are only allowed to specify static urls for scheduled refresh, it severely limits the functionality of the dashboards one can build. 


Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors