Automatic update of the PowerBi DataSet in Power Bi Desktop

[thesle]

Hi, I have a MySQL database configured with ODBC to then connect it to Power Bi, I mainly wanted to know if when I make an insertion into the database the dataset can be updated automatically and not via the update button on Power Bi Desktop.

[v-zhangti · Accepted solution]

Hi, @thesle 

There are different ways to update your Power BI dataset from a MySQL database automatically, depending on the storage mode and dataset type you use. Here are some possible options:

If you use Import mode, you can set up a scheduled refresh for your dataset on the Power BI website. This will allow Power BI to query the MySQL database periodically and load the updated data into the dataset1. You can also refresh the dataset manually from the Power BI Desktop or the website.

If you use DirectQuery mode, you don’t need to refresh the dataset, as Power BI will query the MySQL database directly with every user interaction. However, this may affect the performance and latency of your reports and dashboards.

If you use LiveConnect mode to connect to an Analysis Services model, you also don’t need to refresh the dataset, as Power BI will query the underlying data source in real time. However, this mode requires a gateway to connect to the MySQL database.

Data refresh in Power BI - Power BI | Microsoft Learn

DirectQuery in Power BI - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.