I have created Power BI report, and imported into Azure Workspace Collection, and then embedded the report into my webpage, using api calls...
My question is, I want to refresh the data on a daily basis. How can I refresh the report which is stored in Azure Workspace Collection ?
My data source is SQL Server (Not Azure SQL Database). For this, I heard that there is Gateway.
Could you please explain the step by step approach in oder to configure the Gateway and scheduling Power BI report (present in azure) ?
