Hi John,

 

I finally have the Data Gateway set up and am able to schedule Power BI refreshes. Yay!

 

I am at loss, however, on how to connnect an Excel file to a data source in the Power BI Data Gateway.

 

I have used the "Analyze in Excel" feature to get the ODC file which makes a connection to the Power BI data source through a URL.

 

I thought this was it but it fails to refresh in Excel Services. I believe because it links to a model, but I am not certain.

 

Any advice on connecting Excel to the data source in Power BI Data Gateway?

 

Thanks!

eRic

www.000webhost.com