How to refresh BI report that is connected to a MYSQL database? RRS feed

  • Question

  • In order to build a dynamic report, I connected a MYSQL database to a Power BI report. I connected it with a query that selects and assembles the desired data as needed. I expected that the report data are automatically being updated every so often when a user page view triggers a rerun of the query but it looks like the data in the report do not change when they change in the database. That makes the connection not dynamic. What do I need to do so that database data changes are seen in the report without me pushing manually the Publish button in Power BI Desktop? Thank you!
    Tuesday, May 10, 2016 10:49 PM