Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
4 years ago
Solved

How to Enable Auto refresh / change detection

Hello Team, I am using power bi desktop. I am getting data tables from MySQL server. I wish to auto refresh my dashbord page within time limit or whenever data added in mysql tables, it has to be u...
Need Help
Tips and Tricks
Tutorial Requests
  • Karthik12's avatar
    Karthik12
    4 years ago

    liuqi_pbi 

    Thanks for the input.

    I have tried by publishing it in power bi service where I can get schduled refresh option (we need to install on premises gateway to connect mysql directly to power bi reports) . It seems workable as a alternate way. 

liuqi_pbi's avatar
liuqi_pbi
Resolver III
4 years ago

Hi Karthik12 

 

Change detection feature is included in the Automatic page refresh feature for DirectQuery data sources. It doesn't support Import mode. So you will find it disabled when all tables are in Import mode. You can find more introductions and considerations about this feature from Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs 

 

For tables in Import mode, currently it doesn't support automatic refresh in Power BI Desktop. There is an idea regarding this requirement, you can vote it up at Microsoft Idea (powerbi.com)

 

Hope this helps. 

 

----------------------------------------------------------------------

If this reply helps solve the problem, please mark it as Solution! Kudos are appreciated too!