Forum Discussion

Regular Visitor

11 years ago

Data Refresh not working with Web data

I understand from a support article about data Refresh that Web is among the supported datasources for refresh. I have a complex dashboard with 5 web datasources retrieving JSON data from REST we...

Anonymous

Not applicable

9 years ago

I have run into that error with Web Queries when I try and either leverage parameters or reference other queries in the query set. So things like paginating, and dynamically generating your URLs wouldnt work.

I'm not on the Power BI team, but I would assume they keep these kind of things from working because it could be a big resource hog if you are dynamically generating urls and the query never stops.

Does that sound similar to what you are dealing with?

Alex

Tishchenko
Responsive Resident
9 years ago
Hi Anonymous, Anonymous
Check this posts

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/
- koenverbeeck
  Advocate II
  9 years ago
  Awesome. Those two blog posts of Chris helped me find the solution:
  a combo of relative path and passing along the parameter using Query.
  After publishing the .pbix file, I had to set the credentials on the data set to Anonymous as well.
  (I pass along an API key in the function itself)
- Anonymous
  Not applicable
  9 years ago
  
  I'm suprised Excel based Web data is not supported.
  
  The M-code calls Excel.Workbook......
  
  let
  Source = Excel.Workbook(Web.Contents("https://research.stlouisfed.org/fred2/graph/fredgraph.xls?chart_type=line&recession_bars=on&log_scales=&bgcolor=%23e1e9f0&graph_bgcolor=%23ffffff&fo=Open+Sans&ts=12&tts=12&txtcolor=%23444444&show_legend=yes&show_axis_titles=yes&drp=0&cosd=1987-01-01&coed=2099-02-01&height=445&stacking=&range=Custom&mode=fred&id=DGS3MO&transformation=lin&nd=&ost=-99999&oet=99999&lsv=&lev=&scale=left&line_color=%234572a7&line_style=solid&lw=2&mark_type=none&mw=2&mma=0&fml=a&fgst=lin&fgsnd=2007-12-01&fq=Daily&fam=avg&vintage_date=&revision_date=&width=670"), null, true),
  
  Anyone know if this is on the roadmap?