Deploying a Power Pivot with Power Query Connections - Disable? RRS feed

  • Question

  • I have a Power Pivot that uses Power Query to load the model.  The Power Queries load several csv files that reside locally on my PC.  When deploying the Power Pivot out to the masses, what settings should be made to prevent users from kicking off (refreshing) the the PQ data load since they won't have access to the source files which would then throw an error.



    Monday, February 27, 2017 8:31 PM


  • Protecting the workbook structure should give you the desired result.

    Another way is to edit each query-setting and disable "Refresh this connection on Refesh All". But then an (unsuccesful) refresh would be triggered, if the user selects the table or query and starts the refresh individually.

    Imke Feldmann TheBIccountant.com

    Tuesday, February 28, 2017 6:16 AM