Select OK to connect to the database by using an unencrypted connection, or follow the instructions to set up encrypted connections to SQL Server. If the connection is not encrypted, you'll be prompted with the following dialog. Select the level to apply your credentials to. Select the Database authentication type and input your MySQL credentials in the User name and Password boxes. In the MySQL database dialog, provide the name of the server and database. Select the MySQL database option in the connector selection. To make the connection, take the following steps: Capabilities SupportedĬonnect to MySQL database from Power Query Desktop This component must also be installed on the machine running the on-premises data gateway in order to use this connector in Power Query Online (dataflows) or Power BI Service. Users need to install the Oracle MySQL Connector/NET package prior to using this connector in Power BI Desktop. Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |