I have a Power BI dashboard which has one Excel as a data source. I accidentally introduced a text data type in a date data type cell, so the Power BI stop refreshing since then. I have deleted the rows where the data were introduced and now the Power BI still cant refresh.

To refresh/execute a Python script (calling API endpoints) as a Data Source in Power BI, Microsoft only allows an OnPrem Gateway (Personal Mode), thus requiring the developer of the dashboard to keep their laptop on.