Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
4 years ago
Solved

Get data from MySQL tables

Hello Team, I have connected to mysql db from local host. Server : localhost:3306, db: mysql). But, after got the data, I am viewing only tables like this (.frm file from mysql folder). C:/X...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Karthik12 , Does the current user you are using in power bi have access to that database ?

amitchandak's avatar
amitchandak
Super User
4 years ago

Karthik12 , Does the current user you are using in power bi have access to that database ?

  • Karthik12's avatar
    Karthik12
    Post Patron
    4 years ago

    amitchandak Hi, Thanks for the reply. Yes, I don't have access to that database. I got access through "privilege" option in the db and now it is working fine for me. 

    But, When ever any data get added in that server, How can referesh my page automatically?

    I seen in the modelling--> change detection is disabled by default.