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
mim
Advocate V
Advocate V

auto refresh for web contents does not work in the service

I am pulling zip files from the web, it works perfectly in the desktop but in the service i get this message

 

Query contains unknown or unsupported data sources. Web, http://www.nemweb.com.au/REPORTS/CURRENT/Daily_Reports/

 

there is no parameters, I have done a lot of search and I couldn't find the issue

 

link to the pbix here 

 

Query contains unknown or unsupported data sources. Web, http://www.nemweb.com.au/REPORTS/CURRENT/Da...

1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

Hi @mim

the type of parameters that are relevant in this case are function parameters and not query parameters.

There is one in step "Added custom" in your nem-query. 

It produces a dynamic URL and that's not supported in the service. Therfore you have to use a relative path record in your query. See details here: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=15&cad=rja&uact=8&ved=2ahUKEwjrkfSx6av... 

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

1 REPLY 1
ImkeF
Super User
Super User

Hi @mim

the type of parameters that are relevant in this case are function parameters and not query parameters.

There is one in step "Added custom" in your nem-query. 

It produces a dynamic URL and that's not supported in the service. Therfore you have to use a relative path record in your query. See details here: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=15&cad=rja&uact=8&ved=2ahUKEwjrkfSx6av... 

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

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