Lesson 3 How to get MySQL Server Database Data into Power BI Desktop. Subscribe for free videos…!!!

In this lesson you will learn how to resolve the issue of connecting My SQL Server . And you will successfully load table from MySQL Server to Power BI Desktop. You will see, how to get MySQL Dot-net connector and use it to show MySQL table data on report. Subscribe this channel for more free videos…!!!

[@yanwang6605]

Thank you so much, i spent hours on searching and trying to connect MYSQL to PowerBi, finally after watching this short 6 mins tutorial, everything is solved, thanks

[@bitsanalytics6949]

Glad it helped!

[@shreyapatel4474]

Thank you so much, It's very helpful, finally you saved me☺

[@bitsanalytics6949]

Glad it helped!

[@priteshbagal9176]

You are a savior

[@rickypinaria5059]

Thank you, just did connect my sql data to power BI! Right to the point! Keep it up!

[@bitsanalytics6949]

Glad it helped!

[@bitsanalytics6949]

Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@meditationsounds306]

Thank you so much for this video. it has helped in solving my connection problem

[@sonalithakker6517]

Thank you so much I was trying this for hours and finally your tutorial saved me.

[@bitsanalytics6949]

I am glad you like it..check out my other videos. They might be helpful for your power bi journey. stay tune for more scenario based videos. I support free learning , Please share this channel with your friends and colleagues.

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@prashantsingh1892]

hey thanks man it helped,i was stuck

[@bitsanalytics6949]

Glad I could help

[@Vishnu-fr2kg]

This is a savior. Thank you very much.

[@JeevanChandrakar92]

I have to keep my PC on for refreshes in PBI service.. How can I chuck out my PC's involvement..and refreshes happens directly

[@khoachau4997]

Thank you so much. You made my day

[@bitsanalytics6949]

Glad I could help

[@bitsanalytics6949]

I hope this will fix your problem. Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@danielpaloma6435]

thank you so much for this valuable tutorial!!

[@bitsanalytics6949]

Glad it was helpful!

[@bitsanalytics6949]

I hope this will fix your problem. Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@siddharthatarafder6558]

Thank you so much

[@bitsanalytics6949]

You're most welcome

[@bitsanalytics6949]

Check out this new video. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@hibato-allahsmaali9667]

Hi, hope that you are doing good, thank u for what u did but i don't know why the error kept on showing even though i installed mysql connecter and i refreshed so many times i don't know where the problem is, hope you can answer me.

[@shivikamahajan890]

hey, were you able to solve this error?

[@businessautomation2417]

further, if report is published, how to give credentials for PBI service?

[@bitsanalytics6949]

Share your dashboard with web embedding or use premium capacity.

[@albertoruelas7568]

Hi, is there a way to connect from an other machine? a different one from where the DB is located

[@bitsanalytics6949]

yes

[@albertoruelas7568]

@@bitsanalytics6949 mmm ok

[@chunhingyap]

Does it means to specify the ip where the mysql was installed instead of localhost.. How about port? Need to expose 3306 port to external?

[@bitsanalytics6949]

@@chunhingyap i am working on video on this . will upload soon.

[@bitsanalytics6949]

@Alberto Ruelas I hope this will fix your problem. Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@Mahesh717]

in my system its showing we wouldn't authenticate with the credentials provided ?.....

[@osamakhan3665]

Hi, I have the database in office and when i work in office everything is ok. However If I try to edit query in my home. there is an error it says 'DataSource.Error: MySQL: Host '' is not allowed to connect to this MySQL server'

[@patrykdychtanowski7222]

THX!

[@bitsanalytics6949]

Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@dipto624]

great content .. i needed to know how to authenticate and connect database . 4:59

[@bitsanalytics6949]

please check this new video. I hope this will fix your problem. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@gabrielfernandomanuel5749]

Hi i have deployed my report in the SSRS report server and i have created a Gateway connection on the serve but my report is not updating the data

[@bitsanalytics6949]

You have to configure datasource on on- prem report server. Check your reports datasource properties .you need to setup connection ans credentials there.

[@bitsanalytics6949]

I hope this will fix your problem. Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@c30562]

It shows internal connection fatal error. Error State : 18. What can I take next step?

[@ammarahmad6561]

Thanks a lot Sir

[@bitsanalytics6949]

Keep watching

[@bitsanalytics6949]

I hope this will fix your problem. Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@prenashish4650]

Hello plz how to connect phpmyadmin database to Power bi Plz help Should I need to go for odbc

[@bitsanalytics6949]

see if this video will help you . kzbin.info/www/bejne/m3qZk2yQo5abrqc or send details about your issue.

[@VidharthiRanjan]

Thanks you sir 👍

[@bitsanalytics6949]

All the best

[@bitsanalytics6949]

Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@unpluggedsaurav3186]

yooo

[@khushalkhan2139]

I keep getting this error. "An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.'"

[@bitsanalytics6949]

Try to clean your data before moving to power bi.

[@parmeetkaur1739]

tried to connect MySQL db with bi but I got this error evenif I had MySQL workbench and server 8.0

[@bitsanalytics6949]

Parmeet as I have mentioned in the video first you need to install MySQL Connector. Plz verify this and follow the steps as mentioned in the video.

[@parmeetkaur1739]

@@bitsanalytics6949 I was worried whether it would clash with old configuration or not because mql does create problems in windows and I got stuck months back. Thankfully it worked 🙏

[@bitsanalytics6949]

@parmeet kaur I hope this will fix your problem. Check this new video on same topic. kzbin.info/www/bejne/iXvKo5mdoNaKkK8

[@gunjansingh5348]

Details: "An error happened while reading data from the provider: 'A call to SSPI failed, see inner exception.'" This error is coming unable to connect powerBI with MySQL, can anyone help !