¶ Power BI
¶ Creating Report with SQL Server - Import
Data is static, requires a "Shedule" to refresh the data and need to reload the page.
¶ Creating Report with SQL Server - DirectQuery
Data is dynamic, required to press the Reload button on the page:
¶ Creating Schedules
Use Schedules to refresh Import mode static data:
This mode requires page reload to refresh the data.
To create Schedules the SQL Server Agent has to be running:
By default, it is not running!