Aug 10 2016 09:31 AM
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?