Refresh Power Query data source in Excel upon Burst execution
Kieth Stanley
started a topic
about 2 years ago
My company has several Excel files that are using Power Query as a data source, whether pulling form PBI Dataflows, MS SQL, Oracle etc...
Would like to be able to use a Burst to refresh the Power Query data source in the Excel files, before delivering them to the business.
1 Comment
Bryan Baca
said
about 2 years ago
Thanks for the idea Kieth. InfoBurst uses a third-party solution to read and create Excel files. That solution does not support triggering of Excel data source refreshes. For this reason, we cannot support such an option.
Kieth Stanley
My company has several Excel files that are using Power Query as a data source, whether pulling form PBI Dataflows, MS SQL, Oracle etc...
Would like to be able to use a Burst to refresh the Power Query data source in the Excel files, before delivering them to the business.