Forum Discussion

dcohendumani's avatar
dcohendumani
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's avatar
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?