Forum Discussion
Premium Refresh Limits
After going over the article you sent and doing more research, I discovered a solution. I was able to install and use the MariaDB connector to connect to my MySQL database. Thus, allowing me to create a Direct Query into my database. Then I was able to make sure the settings you described above is configured correctly. Thank you Lucien!!
Hi gfross ，
Power BI doesn't import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes, as the next section on refresh types explains. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings, as in the screenshot below, or force a dashboard update manually by using the Refresh now option.
refer:
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
Best Regards
Lucien
Thank you for your response! I do not have Optimize Performance options for my dataset. I do have the Scheduled Refresh options but it does not contain what you're referring to. The only table in my dataset has it's storage mode set to 'Import'. I cannot change the mode to 'Direct Query' or 'Dual' because the database is MySQL. I tried connecting using the MySQL and ODBC datasources. Am I missing something?
After going over the article you sent and doing more research, I discovered a solution. I was able to install and use the MariaDB connector to connect to my MySQL database. Thus, allowing me to create a Direct Query into my database. Then I was able to make sure the settings you described above is configured correctly. Thank you Lucien!!