Forum Discussion
Schedules refresh on local datasources
Yeah - I found the documentation not the clearest, but once I'd set up the enterprise gateway (wherever you have the personal gateway set up), I then went into Power BI service 'manage gateways and connections' within the gear icon.
Then, like your second image (new connection with gateway cluster), there is a MySQL option under connection type which appears once you've picked a gateway- enter your credentials in there and check it works.
Then, within each reports settings, in the gateway section, you need to map each connection from the dataset to the relevant connection you've set up in service (in the top section - gateway, not the bottom cloud one).
Sorry if this makes zero sense!
HI MainlineData ,
thanks for your reply. The odd thing is that the local files work fine. It´s just the Mysql which gets "defaulted" to cloud.
But now that you have the enterprise gateway, can you connect through it to your local Mysql source?
Yeah - I found the documentation not the clearest, but once I'd set up the enterprise gateway (wherever you have the personal gateway set up), I then went into Power BI service 'manage gateways and connections' within the gear icon.
Then, like your second image (new connection with gateway cluster), there is a MySQL option under connection type which appears once you've picked a gateway- enter your credentials in there and check it works.
Then, within each reports settings, in the gateway section, you need to map each connection from the dataset to the relevant connection you've set up in service (in the top section - gateway, not the bottom cloud one).
Sorry if this makes zero sense!
that worked 🙂 thanks!
little caveat: when you create the data connection to map to the company gateway, the name of the connection needs to match exactly the name of existing, missing data source. This way it seems to work for both local files and the local database.