I want to prompt the 'access web content' popup window when anyone opens my excel file, so people can use choose their own settings.
At the moment it isn't giving the option to chose your permissions - I need the prompt to open when the file opens, so the users can choose from 'anonymous', 'windows', 'basic', 'web api' or 'organizational account.
I don't want to have to ask my users to go to the query tool bar, select 'edit', select 'data source settings', select 'edit permissions', select 'edit' under 'credentials in order to open the 'access web contact' popup.
Is there a way I can trigger it to open every time the file is opened?
i just had this problem!
Select Launch Power Query Editor, then select Data Source Settings, select your data source (mine was already in place), then select Edit Permissions, Edit.