Power Query Security Settings Error RRS feed

  • Question

  • I recently migrated to Office 365 at work as part of a pilot. Power Query has become a key tool for me however since migrating to Office 365 I am unable to use as I continue to receive this error message in the yellow banner at the top of the file once I launch the Power Query addin. "To help protect your security, your web browser has restricted this file from showing active content that could access your computer. Click here for options." I select allow this content and the tool errors out. I am trying to understand what setting I need to change (Power Query Options?, Data Source Settings?, Excel Options setting, Browser settings?). No one at from our internal BT group can help me so I am at a loss. I would greatly appreciate any help others can offer please.
    Friday, September 28, 2018 12:42 PM