question

VKRAM-9705 avatar image
0 Votes"
VKRAM-9705 asked AmeliaGu-msft commented

Error creating a data source in Power BI Gateway to a MySQL database hosted in AWD RDS

I am able to connect to the MySQL AWS database using ODBC in my Power BI Desktop. However when i created an on-prem gateway i couldnt create a data source and getting this below error message. I have already installed the driver in my machine where i installed the gateway. -2147467259
Underlying error message: MySQL: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'. This error could've been the result of provider-specific client software being required, but missing on this computer. To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'MySQL Connector/Net': https://go.microsoft.com/fwlink/?LinkId=278885

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi VKRAM-9705,

Did the answer help you?
If you find the post in the thread is helpful, you could kindly accept it as answer.
If not, I suggest you open a thread in the dedicated Power BI forum so that people there will help you more effectively.

Best Regards,
Amelia


0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi VKRAM-9705,

Welcome to Microsoft Q&A.
According to this thread and this feedback, please try to reboot the PBI Gateway Server.
In addition, your issue is more related to Power BI, and Power BI is currently not supported in the Q&A forums. I suggest you open a thread in the dedicated Power BI forum so that people there will help you more effectively.

Best Regards,
Amelia


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.