I have power bi desktop installed and up and running. Want to publish data to power bi service. While having connection of power bi with desktop version, On publish to service, i need to open gateway to refresh the data. As i have no local source, only data i am using is remote MySQL. So why do i need gateway to have refresh the data meanwhile i am using external data-source. And then what is need of credentials of my external sources.
Is there any way to remove this gateway need and have it without it (through direct connect) ?
