You have a permission or database configuration issue locally. Never try to set up a gateway if you cannot get your desktop to connect. It just won't work. Get with your IT department to assist to get your local desktop app to work, then proceed to the gateway.
Did I answer your question? Mark my post as a solution! Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!
DAX is for Analysis. Power Query is for Data Modeling