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?