Lesson 15 How to Connect MySQL Remote Server (using IP) and load data into Power BI Desktop

preview_player
Показать описание
This lesson covers the scenario asked in the comments of Lesson 3 video.
How to connect MySQL Remote Server (with IP address in network)?
How to fix the authentication problem?
This lesson will answer to all this questions and more.
  1. Bits Analytics
  2. MySQL
  3. MySQL Connector
  4. Power BI Desktop
  5. MySQL Workbench
  6. Remote Server
Рекомендации по теме
MIDI Keyboard Setup 0:02:14

MIDI Keyboard Setup on Mac: Connect Keyboard Lesson 15

Inputs and Outputs 0:08:01

Inputs and Outputs of an Audio Interface explained, lesson 15

Learn Japanese | 0:21:13

Learn Japanese | Minna No Nihongo Lesson 15 Grammar

Control a Pump 0:11:05

Control a Pump with Arduino (Lesson #15)

Learn Finnish! Lesson 0:07:39

Learn Finnish! Lesson 15: In a shop - Kaupassa

Raspberry Pi LESSON 0:39:34

Raspberry Pi LESSON 15: Analog Input on the Raspberry Pi Using the ADC0834

Eureka Math Grade 0:13:13

Eureka Math Grade 5 Module 1 Lesson 15

Beginner Level Listening 0:00:55

Beginner Level Listening test Lesson 13-15 #shorts #sinhvientainang #hoctienganh #learningenglish

Lesson 15 MAX7219 0:21:53

Lesson 15 MAX7219 LED Dot Matrix Module

ScratchJr Coding Lesson 0:11:00

ScratchJr Coding Lesson 15 | How to make a Jumping Game | Beginner Tutorial | How to Code Games

Could Have Should 0:06:16

Could Have Should have Would have | Lesson 15 Spoken English Malayalam | Basic English Grammar

Chess lesson # 0:09:40

Chess lesson # 15: Game analysis | Miniature game with the Evans gambit | Learn Chess the right way

Testing REST API 0:04:45

Testing REST API with Jbehave - Lesson 15: Install Jenkins

Learn Hindi Through 0:09:06

Learn Hindi Through English - Lesson 15

HOW CHINESE STUDENTS 0:00:23

HOW CHINESE STUDENTS SO FAST IN SOLVING MATH OVER AMERICAN STUDENTS

particles of Nasb 0:13:00

particles of Nasb before verbs EXPLAINED | Lesson 15 | Arabic101

How To Play 0:19:05

How To Play Piano for Beginners, Lesson 15 || Minuet in G

Must Know Minor 0:07:37

Must Know Minor Guitar Chords | Beginner Guitar Lesson #15

Lesson 15. Equations 1:43:18

Lesson 15. Equations | Maths Session for Grade 09

English Conversations Lesson 0:00:59

English Conversations Lesson (Running Into A Friend) #shorts

Learn Japanese | 0:29:37

Learn Japanese | Minna No Nihongo Lesson 16 Grammar

How Curd Looks 0:00:57

How Curd Looks under a Microscope | Lactobacillus Bacteria in Curd under Microscope #shorts

EngageNY Grade 5 0:17:26

EngageNY Grade 5 Module 4 Lesson 15

Learn Italian in 0:12:06

Learn Italian in 30 Days | #15 | The Verb 'To Be' (Eng/Ita Subs + WORKBOOK)

Комментарии
Автор

Thank you so much for your video...I am so grateful...I surfed all around google but I can't find the solution for it - Man, you made my day...God Bless you

vijitsahu
Автор

Always handy having a my squirrel connector...

Emexrulsier
Автор

Thank you very much for the tutorial !

Side question : How much RAM do you guys use for data processing and what do you recommend ?

jeanthuriere
Автор

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

businessautomation
Автор

Hi sir i installed mysql connector and also install odbc connector but till power bi showing error connector need one or more components.... Error. I have 64 bit system plz help me in this. Thank you

vasimishaq
Автор

Thanks for creating a good video tutorial for connecting MySQL Remote Server with IP address. Based on my use case, I think the only downside of this approach is to grant All Privileges to the user and it means that the client will have full access and privileges on the database using MySQL workbench if the client user have the password. Perhaps the workaround is do not 'set “Save Password in Vault” in MySQL workbench. I wonder whether it will still work.

chunhingyap
Автор

hey, it appears an error after i put the credencials
"Character set 'utf8mb3' is not supported by .Net Framework."
Can you help me, please ?

eduardocardoso
Автор

It is not working on my end. The database is on a Phpmyadmin server. I dont know why

pauwelsgnanih
Автор

like wise how u will get data from mysql which is placed in remote server , to power bi .how do i get data from sql server which is placed in australia to power bi desktop which placed in home like work from home job

pagidiramesh
Автор

Bro can you please make a video on how to work with sap bw driver within power bi

arunsaini
Автор

Hi Sir, Can you please tell the syntax how to create similar way in SQL Server

hemasundarreddy
Автор

How to connect live web phpmyadmin MySQL database to power BI desktop ?

vasimishaq
Автор

Hi sir i installed mysql connector and also install odbc connector but till power bi showing error connector need one or more components.... Error. I have 64 bit system plz help me in this. Thank you

vasimishaq