I have a Personal Gateway. It works on other Power BI reports. Just published a new report/dataset. When I choose schedule refresh I see that it "feels" all my credentials are invalid. So I select "Edit Credentials". For most of the sources the only Authentication Method available to choose is WindowsWithoutImpersonation. So I select that and I hit sign in. And then a spinning circle of dots commences that never ends. What am I doing wrong?
Interestingly 2 of the sources (which are listed as "Web") let me choose OAuth as the Authentication Method. For those, when I hit sign in it works. It seems to be the non-Web sources (Excel files in this case) that only allow for WindowsWithoutImpersonation that are the problem.
What data source do you use? WindowsWithoutImpersonation Authentication Method use Windows Authentication. When a user connects through a Windows user account, datasouce validates the account name and password using the Windows principal token in the operating system.
The data sources that "hang" (i.e., the ones that only have WindowsWithoutImpersonation as the Authentication Method) all appear to be Excel files on a corporate server except for one of the sources which is a folder on the corporate network full of csv files.