Forum Discussion
Unable to refresh an Excel Workbook linked to a dataflow
Hello, I have an excel workbook that is linked to a dataflow in the same workbook. My understanding was that I could set up a refresh for the excel book so that whenever the data flow is refreshed, ...
just failed with similar setup: connect excel to dataflow, refresh on desktop works, but fails in excel online.
Verbindung: Abfrage - banner
Fehler: COM-Fehler: Microsoft.Sql.Analysis.ASOnPremisesDataAccess, Failed discovery for connection string provider=Microsoft.Mashup.OleDb.1;data source=$Workbook$;location=banner;extended
Microsfot, any comment on this?