This script can be used to generate the following SQL Objects to monitor your PowerBI Refresh Artifacts
- Tables and views
- PBI Object Table and View
- PBI Refresh History Table and View (view assumes the EST timezone)
- Stored Procedures
- Stored Procedures to merge refresh history from the PowerBI REST API