"connect" button is not showing on the authentication screen

[amcneil32]

Hello, i have a user who is not able to refresh a query for a report. It is a query pulling from a SQL table. It's strange but the "connect" button is not showing on the authentication screen. The user does have read permissions to the table.

[amcneil32]

@V-pazhen-msft , thanks for the reply. When the user attempts to clear permissions there isnt any yes or no button to click on. Also excel freezes up and we had to end the task with task manager.

[V-pazhen-msft]

@amcneil32 

Clear the permission in datasource setting and connect again.

Power Query - Change the Source Data Location - Excel Off The Grid

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.