cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koenverbeeck Regular Visitor
Regular Visitor

Re: Data Refresh not working with Web data

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)

Blog: sqlkover.com
Highlighted
Evan_at_DD Frequent Visitor
Frequent Visitor

Re: Data Refresh not working with Web data

 

I'm suprised Excel based Web data is not supported.

 

Capture.PNG

 

 

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_scal..."), null, true),
   

 

Anyone know if this is on the roadmap?