I am able to connect to my oracle db using power bi desktop and can alspo do data refreshes on power bi service, but when I try to create a dataflow or a datamart then it says invalid credentials, to connect I need to input the server, data gateway, authentication kind, username and password.
For server I am guessing thats just a general name of your choosing, for data gateway it the on premises gateway I normally use, for authentication kind I use basic and for username and password its the sames credentials I use in my power bi desktop files, I use in sql developer and even on power bi service the gateway uses this data source to do data refreshes.
So not sure why it is not connecting.
